Some Data Compression Commands for SQL Server 2008 and 2008 R2
One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data...
2010-05-17
1,246 reads
One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data...
2010-05-17
1,246 reads
There has been quite a debate going on at SQLServerCentral about a DBA journeyman certification. There are a couple good...
2010-05-17
963 reads
Next Monday, I shall be driving the Smart down to Burlington, VT, again to visit Roman Rehak's Vermont SQL Server...
2010-05-17
646 reads
Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in...
2010-05-16
695 reads
SQL Server Reporting Services R2 – Publishing Report Parts
SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish...
2010-05-16
4,196 reads
Study Tips for the SQL MCM Exams
I met the new rotation of the SQL Server Certified Master program on Friday....
2010-05-16
2,150 reads
Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more innovation areas are not well known… Is Microsoft losing the cloud apps? Let me share with...
2010-05-15
13 reads
Microsoft is associated almost exclusively with Windows and Office. Unfortunately a lot more...
2010-05-15
11 reads
If you’ve ever read Spider-Man or spent any sort of time around the Marvel Universe (movies included) you’ll have no...
2010-05-15
652 reads
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a...
2010-05-15
4,783 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers