SQL Server

SQL Server Community

SQL Server Blogs

Rohit Garg
Follow /17 Sep 2014 at 10:24am / SQL Server

Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !

The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
16 0 /
Rohit Garg
Follow /17 Sep 2014 at 10:20am / SQL Server

Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !

The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing...
16 0 /
Richard_RP
Follow /17 Sep 2014 at 7:53am / SQL Server

Cumulative Updates – SQL Server 2012 SP2 CU2

As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 2! Service Pack 2 CU#2 can be applied to any of the following Microsoft SQL Server 2012 editions, providing Sp2 has already been...
19 0 /
SQLDBAPros
Follow /16 Sep 2014 at 3:03pm / SQL Server

Tuesday Tips: Five Considerations for Transaction Workload Analysis

Performance. Problem. Two words DBAs never want to see together. Yet avoiding (or eliminating) database performance problems can eat up hours, days or weeks of an administrator’s time. We have a ton of resources available on ToadWorld. And in previous...
171 0 /
Larry Leonard
Follow /15 Sep 2014 at 7:30pm / SQL Server

Display ETA and Percent Completed for BACKUP or RESTORE Commands

This code will show you the estimated time of completion and percent completed for currently running BACKUP or RESTORE commands. -- Shows both backups and restores. select session_id as 'spid' , command as 'Command' , start_time as...
65 0 /
David Dye
Follow /15 Sep 2014 at 4:06pm / SQL Server

Dealing with Duplicates in the Data Flow

I frequently see posts in the MSDN forums requesting assistance in removing duplicate values from a source, other than SQL, to be entered into a SQL Server destination.  There are several options to accomplish this, but this post is meant to address the...
37 0 /
Kenneth Fisher
Follow /15 Sep 2014 at 1:00pm / SQL Server

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick. The other week I did a post on SCHEMABINDING and Diana sent me this great link on SCHEMABINDING UDFs . In it TomErv discribes SCHEMABINDING...
63 0 /
Rohit Garg
Follow /15 Sep 2014 at 10:15am / SQL Server

Creation & Deletion of Database Snapshot by SQL Agent Job

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear...
70 0 /
Nakul Vachhrajani
Follow /15 Sep 2014 at 4:30am / SQL Server

#0346 – SQL Server – Using CASE with a PRINT statement

Informational and alert messages during execution of a T-SQL script are the most preferred method to update the user on the progress of the task being executed. These messages are generated by the various PRINT statements embedded in the script. Often...
93 0 /
Jen Stirrup
Follow /13 Sep 2014 at 3:37pm / SQL Server

Counting is Easy, Measuring is Hard! Dashboard Design

Counting is easy, Measuring is Hard! Dashboard Design from Jennifer Stirrup
1491 0 /
Jason Strate
Follow /12 Sep 2014 at 5:00pm / SQL Server

Reblog: September 5 to September 11

Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
58 0 /
David Dye
Follow /12 Sep 2014 at 3:46pm / SQL Server

What are The Different Types of Database Backups?

If you are just beginning SQL Server database administration then you might not be familiar with the different types of database backups that are available and exactly what they backup.  This post is going to outline the different types of backups and...
73 0 /
Tracy McKibben
Follow /12 Sep 2014 at 1:00pm / SQL Server

Friday Followup For September 12, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
146 0 /
Chris Webb
Follow /12 Sep 2014 at 9:30am / SQL Server

Counting Customers Who Have Bought All Selected Products

Market basket analysis is a fairly well understood problem for SSAS – it’s best handled using many-to-many relationships, as shown in the excellent The Many-to-Many Revolution   white paper. However the other week I was asked a question that was...
70 0 /
Basit A. Farooq
Follow /11 Sep 2014 at 7:51pm / SQL Server

SQL Server: Converting binary data to a hexadecimal string

Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data to a hexadecimal string characters? Solution Before SQL Server 2005, it was not...
74 0 /