Duplicate rows in a table
I recently got the following email:
“I just keyed in two rows into a table with all identical column values. How...
2013-02-11 (first published: 2013-02-04)
3,253 reads
Kenneth Fisher
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,341 reads
EXECUTE, not required, but advisable.
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
768 reads
Small changes, big effects
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,253 reads
My view isn’t reflecting changes I’ve made to the underlying tables.
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.
Over...
2013-01-29 (first published: 2013-01-21)
3,840 reads
Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
930 reads
IsMSShipped
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t...
2013-01-23
1,510 reads
Using New Horizontal/Vertical Tab Groups
This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently....
2013-01-17 (first published: 2013-01-14)
3,290 reads
What port is my instance listening on?
I just had the interesting task of finding the port number that one of the instances I deal with is...
2013-01-08
1,696 reads
How I like to learn a t-sql command
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands...
2013-01-07
841 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers