TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,521 reads
Sheldon Hull
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,367 reads
View computed columns in database
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
568 reads
On how to Googlify your SQL statements for future searching
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,294 reads
Get synonym definitions for all databases in server
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
805 reads
Calculating the next beginning of month and the current end of month
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,217 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,597 reads
snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
351 reads
Native SSMS a second class citizen no longer…
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
912 reads
dynamic sql and a char crash
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
426 reads
Blogs
Index Maintenance Can Change NORECOMPUTE Settings
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
So You Think You Should Get a Radio
This is not database related, so if you’re not interested in hearing about something...
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Forums
fetch an execution plan from SQL Server's buffer cache
Comments posted to this topic are about the item fetch an execution plan from...
A way for the team to keep track of changes made
Is there a best practice way for the team to keep track of changes...
SQL Query Performance with Left Join
I have a query that is performing poorly It has a left join to...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers