Paul White

Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 8,416 total)

RE: Answers to Your QOD

Anirban Paul (3/22/2010)
Hey guys this is a great community but anybody thought who made this community "GREAT"? Is it Steve or Jeff Moden or GilaMonster or Paul...

March 22, 2010 at 8:06 am

#1137608
RE: Denormalization Strategies

Tom.Thomson (3/22/2010)
I think Paul's 3 stars were over-generous.
I did waver over the two star option, but went with 'average' in the end.
You are probably right, though. Too late now!...

March 22, 2010 at 8:04 am

#1137607
RE: Today's Random Word!

Spanner

March 22, 2010 at 7:22 am

#1137580
RE: deletion of 2 million records

David-Leibowitz (3/22/2010)
Easiest way? There are several and these work in 2000, 2005, 2008. This has not been tested in 2008 r2.
Method 1:
Involves taking hammer to harddrive
Method 2:
harddrive + lighter fluid...

March 22, 2010 at 7:21 am

#1137579
RE: Representing a hierarchy from comma separated values

I haven't had time to analyse that solution fully, but I sure hope it doesn't depend on TOP 100 PERCENT...ORDER BY working as it did in SQL Server 2000. ...

March 22, 2010 at 7:20 am

#1137577
RE: How to loop through buffer table and pass each record value to another SP?

Just a quick point. In all the tests I have ever seen, there is essentially no performance difference between a correctly-written cursor, and any of the WHILE loop methods.

March 22, 2010 at 7:16 am

#1137572
RE: Tiny virtual machine outperforms a big physical box?

Roust_m (3/21/2010)
Paul White NZ (3/19/2010)
Roust_m (3/15/2010)
Sorry, I got one thing wrong here, the execution time is about the same for 5 records on both servers if I use:
SET STATISTICS TIME...

March 22, 2010 at 2:14 am

#1137442
RE: Query plan re-use

Roust_m (3/21/2010)
Ok, this is what I got for this query:
name,MB used
SQL Plans,6356.898437
Object Plans,378.179687
It looks like SQL Plans are using the most of it. So I guess I do at...

March 21, 2010 at 5:55 pm

#1137382
RE: DateTime input with time always at 00:00:00.0000

rich-521822 (3/19/2010)
SELECT CAST(FLOOR(CAST(GETDATE() as FLOAT)) AS DateTime)
Casting a date to a float relies on undocumented internal behaviour, and is therefore a bad idea. In 2008, none of the new...

March 21, 2010 at 5:50 am

#1137329
RE: Deleting data from large table

george sibbald (3/21/2010)
...its up to you which code you want to use in this instance, both do the same thing.
Not quite the same, at least not exactly. ROWCOUNT with...

March 21, 2010 at 5:34 am

#1137327
RE: Detach and Attach database move filegroup

arnold-491793 (3/20/2010)
Paul White NZ (3/20/2010)
Small point: sp_attach_db is deprecated and will be removed in a future version. Use CREATE DATABASE...FOR ATTACH instead.
There is a good SSC article on this...

March 20, 2010 at 10:46 pm

#1137307
RE: deletion of 2 million records

Natalie C (3/20/2010)
I did mean partitions in partitioned tables. But since we don't have enterprise edition I started doing the delete in batches based on Lynn's method posted in her...

March 20, 2010 at 10:42 pm

#1137306
RE: Are the posted questions getting worse?

Matt Miller (#4) (3/20/2010)
I actually like the .NET name for it ("chaos"), even over read uncommitted! It's at least accurate in that it's not without some risk.....
Wow...that brings back...

March 20, 2010 at 10:37 pm

#1137303
RE: simple recovery model Log truncation

How To Delete a Large Number of Records[/url]
Limiting Deleted Rows by Using TOP

March 20, 2010 at 10:29 pm

#1137301
RE: email failure notification

Henrico Bekker (3/18/2010)
I dont specifically for success/failure, but a log is kept.
There is a History tab on each Operator in SSMS 2005, which indicates most recent notification attempts.
🙂

March 20, 2010 at 10:23 pm

#1137300

Viewing 15 posts - 4,966 through 4,980 (of 8,416 total)