tfifield

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 508 total)

RE: Hidden RBAR: Counting with Recursive CTE's

Excellent article Jeff!
It really puts the kabosh on the rCTE method. It also shows something that I found a while back. That the old fashioned tally table in...

August 9, 2011 at 11:37 am

#1366103
RE: SQL Server 2008 Convert Rows into INSERT statement

This is a long thread and I didn't have time to really study it, but I believe the easiest answer was posted a page or 2 earlier. I've done...

August 5, 2011 at 12:12 pm

#1364571
RE: Massive Buffer I/O Wait Times

coronaride (8/2/2011)
It is a SELECT only, with multiple joins on PK-FK relationships to child tables. There is no inserting, updating, or deleting.
As far as the number of concurrent processes...

August 4, 2011 at 2:59 pm

#1364003
RE: Index Creation is Slow After Duplicate

Remi,
The total size of the DB was around 2 GB. The culprit was the main table used for orders and installations. It's non-clustered PK was a GUID (ouch!)....

August 3, 2011 at 12:15 pm

#1363266
RE: Index Creation is Slow After Duplicate

I can't agree more with Ninja's comments on tables needing clustered indexes. A quick way to look at the tables indexes is:
sp_helpindex 'TableName'
If there really is no clustered index...

August 3, 2011 at 11:43 am

#1363254
RE: No Parallelism When using Row level function

Has anyone bench marked iTVF's both with and without SCHEMABINDING. I seem to recall an article by Paul White about iTVF's recommending that option so I use it with...

August 3, 2011 at 11:30 am

#1363243
RE: Can I use a case statement in a column default?

Steve Jones - SSC Editor (8/2/2011)
Thanks for the catch. I thought that was a restriction, but apparently my memory is fading.
Father time eventually gets around to us all :crying:

August 2, 2011 at 4:18 pm

#1362752
RE: Can I use a case statement in a column default?

Ninja's_RGR'us (8/2/2011)
I C.
BTW it's Remi
😉
Oops! Got it right now.
Todd

August 2, 2011 at 4:15 pm

#1362747
RE: Can I use a case statement in a column default?

Ninja's_RGR'us (8/2/2011)
srferson-957148 (8/2/2011)
Oh, yeah. I've used case statements in computed columns before. That's actually part of the reason I was hoping there was a way to do it in default....

August 2, 2011 at 12:26 pm

#1362479
RE: Index Creation is Slow After Duplicate

Jayanth_Kurup (7/29/2011)
When inserting the data , are u performing an ordered insert or do you have a clustered index performing sort operations?
the above post has already been discussed below
http://www.sqlservercentral.com/Forums/Topic531822-360-1.aspx
http://msdn.microsoft.com/en-us/library/ms189858.aspx
Chris,
I'm not...

August 2, 2011 at 12:17 pm

#1362468
RE: Can I use a case statement in a column default?

Steve Jones - SSC Editor (8/1/2011)
The default isn't an expression run against the row. It's a value. Same for computed columns, these don't allow logical expressions.
A trigger is the best...

August 2, 2011 at 12:08 pm

#1362445
RE: Except vs. Left Join vs. Not Exists

SQLkiwi (7/29/2011)
tfifield (7/29/2011)
I hadn't actually thought INTERSECT and EXCEPT through to the DISTINCT part. When you look at it that way, then it is likely to not perform quite...

July 30, 2011 at 10:56 am

#1361245
RE: Except vs. Left Join vs. Not Exists

Paul,
I found your explanation quite informative. I hadn't actually thought INTERSECT and EXCEPT through to the DISTINCT part. When you look at it that way, then it is...

July 29, 2011 at 1:54 pm

#1361107
RE: Partitioned data (Non Enterprise SQL), Table-Valued Parameter and Upsert

About the only way I've ever been able to get something like this to work is with INSTEAD OF triggers on the View. One for INSERT and another for...

July 29, 2011 at 12:57 pm

#1361044
RE: merge, with or else?

Try adding Comment to the GROUP BY clause:
GROUP BY Target_ID, Comment
Todd Fifield

July 27, 2011 at 10:54 am

#1359503

Viewing 15 posts - 136 through 150 (of 508 total)