Query Plan Oddities: Two Identical Missing Indexes
Brent demos a single query plan that asks for 2 identical indexes on the same table.
2017-12-26
3,142 reads
Missing Indexes
The DBA's Essential Index Monitoring and Maintenance Tasks
Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
2018-03-09 (first published: 2016-02-15)
7,926 reads
2016-03-11 (first published: 2014-09-11)
2,749 reads
Index Utilization Trending
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
2014-05-05
6,787 reads
The Ultimate Missing Index Finder
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
2013-01-07 (first published: 2008-08-01)
20,235 reads
RE: Converting Float to decimal(5,1)
The use of float aside, I think there is a problem with your statement.If you are converting numeric(5,1) to float then you will get either an exact value or an approximation with a lot of decimal digits. The problem you stated with 100.1 is not a problem as 100.1 in a numeric(5,1) will be converted […]
2005-03-08
RE: Windows defragmentation
Autogrow in small increments will cause major fragmentation and interleaving of your SQL files if you have multiple DBs growing. Shrinking log files and letting them grow back routinely will cause issues also. I have found that seperating the bakcup files to their own disk is one of the best things you can do to help […]
2005-02-09
setting an alert on new table creation
Hi. I want to set an alert on my production databases so that when a new user table gets created I'm notified. Can someone point me in the right direction on how to do this or is this even possible? Juanita
2005-01-21
Equivalent of MS Access FIRST() function in SQL Server 2000
Hi,Is there any equivalent of MS Access FIRST() function in SQL Server 2000?I am looking for a workaround of FIRST function in SQL Server. Please help me out.Bye,Kamalanathan T.
2004-09-14
347 reads
Help with CASE
I have written the following CASE statement for SQL7 which works fine but I would like to add the "year" on the expression2. Is there a way, could you advise?SELECT year(BillingDate)+ "Calendar Month" = ---- this option1 does not work or CASE WHEN DATEPART(month, BillingDate) = 1 THEN "January" +DATEPART(year, BillingDate)----this option2 does not work either […]
2004-09-11
4 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers