You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try to declare a variable and assign it a value in…
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common one. In most of cases the default value is not…
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all about. The event kicks off at 12:00 GMT on Sep…
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU) For a fresh install if you…
SSMS reports are one of the best ways to pull some great deal of Server level or Database level information within SQLServer. Today I was running the ‘Disk Usage’ report…