List all Objects and Indexes per Filegroup / Partition
Today, I received a call from friend asking how he can find out which database object belongs to which filegroup.
Well...
2013-03-03
1,674 reads
Baton Rouge SQL Server User Group
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge,...
2013-03-03
713 reads
Shorten Your PowerShell Prompt
Recently, I’ve been getting very annoyed by the length of the default PowerShell prompt. Most of my work starts in my Documents folder, so with the default prompt, I’m...
2013-03-03
28 reads
FileTable: SQL Server 2012's little gasp-maker
When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”? Was it...
2013-03-02
1,824 reads
MDX #27–Who are Ascendants?
Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often use in...
2013-03-02
2,462 reads
Script to clean up “Windows” logins no longer in AD
I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...
2013-03-12 (first published: 2013-03-01)
4,160 reads
When was the last successful backup?
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
388 reads
The Saddest Thing I Ever Heard a Manager Say
I am currently going through the process of looking for a new opportunity for my career. I’m going through the...
2013-03-08 (first published: 2013-03-01)
6,050 reads
100th blog post
Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...
2013-03-01
572 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
934 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers