DB MAXDOP Settings

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.

What MAXDOP Setting Should be Used for SQL Server

I have a busy SQL Server and notice that several queries are running in parallel. I know I can set the max degree of parallelism setting, but what MAXDOP should I use?

Configuring the Maximum Degree of Parallelism

How to configure settings to limit the number of processors used in parallel query execution

RE: ORDER BY varchar data type

This doesn't work if the inserts are not done in order:INSERT INTO #Test Select '2B' as 'Column' INSERT INTO #Test select '2A' as 'Column'SELECT * FROM #Test ORDER BY CONVERT( integer, dbo.RemoveChars( [Column])) ASC Column     ---------- 1 2 2B 2A 3 3A 3B 3C 10 11This is probably one of those things that you either […]

XML Bulk Load & Truncating Data

I have a table with a number of columns type varchar(70), and a few others of specific sizes taking it up to the maximum row size.The data for the varchar(70) columns occasionally exceeds 70 characters, and I want this simply truncated, however I cannot do this in the application that creates the XML Files because this […]

RE: Questions to ask a possible DBA

With apologies to Nancy White In Dilbertlandia, Everyone's a bozo        Nobody's got a brain  (oooh!  oooh!)It's a place where being a peon        Does nothing for your self esteem.... 

RE: Stored Procedure

Personally I would consider doing like so. Replace all occurrances of @DateHolder with DATEADD(ss,-1,DATEADD(d,DATEDIFF(d,0,GETDATE()+1),0)) in your query code and get rid of the variable declaration. Replace @tdate with GETDATE() and get rid of variable declaration. Not really sure you need SET DATEFORMAT so say good-bye to it. Then try this. CREATE PROCEDURE GetFrontDeskData;1 @PracticeID bigint, […]