A second week at SQLskills – performance tuning
G’day,
Back in February, I was lucky enough to attend a week of training on SQL internals from the people at...
2011-08-14
1,173 reads
Blog Posts
Change User Desktop Folder Path by Using PowerShell
We could change your desktop folder location by using the following powershell script. Actually we need to change values of...
2011-08-14
5,236 reads
Counting code lines in SPs with Powershell
One of interesting tasks I once had is to check the # of code lines for all user stored procedures (SPs)...
2011-08-14
1,402 reads
Great new analytical functions in SQL Server 2011 “Denali”
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
650 reads
Recursively Enumerating Local and AD Groups
If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy...
2011-08-14
4,251 reads
Database Administration Operation Road Map
In my company, every two years, we have a tradition to collectively ponder at the technology road map for the...
2011-08-13
2,339 reads
Gradually Deleting Data in SQL Server
If you have a situation where you have a very large table in SQL Server, where you need to periodically...
2011-08-13
1,618 reads
SQL MCM Training – Day 5
Today I've not taken too much notes, because the whole afternoon was about the Management
Data Warehouse and Multi-Instance Management. But...
2011-08-13
1,377 reads
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post.
"She can dig it!"...
2011-08-12
640 reads
Check Mount Points and Disk Free Space with PowerShell
Those who know me will know that this post is a little out of the ordinary… I am posting about...
2011-08-12
4,104 reads
Blogs
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...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
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