T-SQL Tuesday #40 - Proportional Fill within a Filegroup
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,884 reads
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,884 reads
Just for the record, this happens to be one of my favorite interview questions to ask candidates.
At some point in...
2013-03-05
2,312 reads
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,430 reads
Per Books Online, DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. Basically it shows you...
2013-02-14 (first published: 2013-02-05)
5,422 reads
T-SQL Tuesday - This month's party is hosted by Wayne Sheffield (blog|twitter), and the topic is about Powershell and how to use...
2013-02-12
8,091 reads
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
7,923 reads
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,282 reads
For years, actually more like a decade, I've been saying that I'm going to get certified in SQL Server. Well...
2013-01-15
790 reads
Have you seen this type of an informational message in your SQL errorlog before? If so, then I hope the...
2013-01-07
1,061 reads
In a previous blog post, I demonstrated how you can use an undocumented stored procedure, master.sys.xp_dirtree, to list all files...
2012-12-31
22,680 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers