2008-03-12
4,099 reads
2008-03-12
4,099 reads
In this article Dinesh Priyankara describes how schema comparison can be performed using Visual Studio Team Edition for Database Professionals.
2008-03-11
1,783 reads
When is it okay to let SQL Server to make a statistic for columns in your queries, and when should you take those statistics and make an index out of them? What I do is to test all of my procs, and if they generate system statistics (_WA_SYS%), then I add an index to the table for the column in the statistic. But is this a good practice?
2008-03-11
3,488 reads
2008-03-10
2,409 reads
Although a few different options (Management Studio, system stored procedures, system views, custom scripts, etc.) exist to determine your permissions in SQL Server, in this tip we want to outline the functionality from the fn_my_permissions table valued function.
2008-03-10
4,446 reads
The Trash Destination is now available for SQL Server 2005 and SQL Server 2008. The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement.
2008-03-10
1,272 reads
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
2008-03-07
3,320 reads
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
2008-03-07
2,625 reads
Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.
2008-03-06
2,556 reads
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
2008-03-06
1,574 reads
By Brian Kelley
On April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you...
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
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