Autogrow bug – fixed with Denali
Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...
2011-08-23
1,873 reads
Blog Posts
Computed Columns and CASE
I wrote about computed columns recently, but I didn’t realize that a logical expression could be used here, such as...
2011-08-23
28,933 reads
Defining Your Culture
Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...
2011-08-23
646 reads
Disk IO performance and SQLIO
Performance testing a new disk subsystem from a SQL Server perspective is one of the fun aspects of DBA work....
2011-08-23
3,446 reads
Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your current session in a table. Useful when you forget...
2011-08-23
16 reads
Get All SESSIONPROPERTY Values for Your Session
As a follow-up to my SERVERPROPERTY() post, this is a quick script to grab all the SESSIONPROPERTY() values from your...
2011-08-23
859 reads
Help with testing Denali, SQL Server 11
Earlier this week, Dan Jones, one of the Microsoft employees on the SQL Server team, wrote a blog post asking...
2011-08-23
1,021 reads
Interview with SQL Server MVP Grant Fritchey
Grant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas,...
2011-08-23
1,639 reads
Running totals in “Denali” CTP3
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....
2011-08-23
791 reads
SQL Server – Hide an Instance of SQL Server
You can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect...
2011-08-23
2,107 reads
Blogs
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
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