|
|||||
|
SQL Server 2012 Release Candidate is now Available from SQL Server Team blog The Data Scientist from BuckWoody 7 Scaling Strategies Facebook Used to Grow to 500 Million Users HighScalabilty 10 Sloppy Social Media Mistakes to Fix NOW from Hubspot Blog What is Hadoop? And Why is it Good for Big Data? from The Data [...] This is the second time I’m writing a post in the “Meme Monday” series and this time it originates from Tom LaRock (blog | twitter). The topic is : What #SQLfamily means to me. This weekend I participated in a #SQLfamily reunion in Washington, DC. Some might argue that this is called SQL Saturday #96 [...] John Sterrett blog|twitter asked a question about “How do I loop by rowcount in SSIS? I have a table with 5 million IDs and would like to loop to process 10K at a time. #sqlhelp” This cannot be done natively in SSIS but you could create a stored procedure that uses the concept known as [...] I am deeply honored that I was chosen to present 2 sessions at SQL Saturday #96 in Washington, DC this Saturday, November 5, 2011! Location is: Microsoft MTC 5404 Wisconsin Ave, Suite 700 Chevy Chase, MD 20815 View Larger Map Subway: Friendship Heights Metro Station SQLSaturday is a training event for SQL Server professionals and those [...] Recently I switched my ISP from AT&T DSL (I know … what was I thinking) back to Comcast. The process went thru very quick and in 30 minutes my old cable modem was hooked up and provisioned and was seeing 23 Mb/s speeds. with 11ms response time. But… wait. As soon as I started using [...] Last week Erin Stellato (blog| twitter) has asked a very interesting question on Twitter that triggered this post: So how is it you can have good perf in Oracle, w/o IOTs, but in SQL Server, everyone says need CIs for good perf? There are two aspects to that question What is the difference between index [...] Welcome to the first Meme Monday! This idea was brought to life by Thomas Larock (Blog|Twitter). Here’s mine Real DBAs never use DBCC SHRINKDATABASE.Because they know better! For those of us that com from an Eastern European country, Scorpions is a legend. Their songs have made us strong and gave us the force to go forward like a “Wind of change”. But sadly they have announced that their newest album: “Sting in the Tail” Is also their last. Thank you for keeping [...] Tonight we started the fire in the outdoor fireplace enjoyed the warmth of the fire and in the end I roasted chestnuts in the hot embers. It’s funny how memories are triggered by simple things like a smell or an object. Source: Flickr All of a sudden while roasting the chestnuts my mind wandered [...] I recently saw the worst example of how not to design a table and indexes in SQL Server. So here it is: Table1(UserID,ActivityID,ActivityType,AddDate) Role : Log any activity that a user is invited for. PrimaryKey: … Wait for it … tada : UserID,ActivityID,ActivityType,AddDate … Wait you say …. YES … all table columns are used [...] Eduard gives us the following problem: The result is that every 4 years for a day you realized the money spent on a Zune are wasted http://www.engadget.com/2008/12/31/30gb-zunes-mysteriously-begin-to-fail-at-12am-december-31st/ Now for the Microsoft solution (Please refrain from ROTFL ! ): Follow these steps: Disconnect your Zune from USB and AC power sources. Because the player [...] Wishing you all a Happy New Year!!! |
|||||
|
Copyright © 2012 Positively SQL - All Rights Reserved |
|||||