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,686 reads
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,686 reads
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge,...
2013-03-03
718 reads
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
37 reads
When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”? Was it...
2013-03-02
1,834 reads
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,483 reads
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,167 reads
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
393 reads
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,056 reads
Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...
2013-03-01
579 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
936 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers