Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,476 through 50,490 (of 59,099 total)

RE: SQL Query match rows in one table

I suppose... instead of doing an UPDATE using the method I suggested, it could be just a SELECT as part of the view.
The real question would be, what are you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2008 at 10:50 am

#817022
RE: getdate() accuracy

Shifting gears a bit, Barry... do you realize the link in your signature line is broken?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2008 at 10:47 am

#817021
RE: getdate() accuracy

Way too funny! 🙂 Heh, I guess THAT's why Steve limits the size of the Avatars :hehe:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2008 at 10:44 am

#817020
RE: help with duplicates delete please

Michael Meierruth (5/18/2008)
If your transaction log is 'going to blow' it will do so with or without the delete crawler. Nevertheless, check your db recovery mode setting.
Good catch... I should...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2008 at 10:36 am

#817018
RE: Recursive Queries in SQL:1999 and SQL Server 2005

Nicely done… Recursion is fine for ad hoc hierarchical lookups, but, if I may suggest, using recursion to "step through" things, like that which occurs in a "split", is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 18, 2008 at 10:17 am

#817013
RE: Database Weekly Update for May 19, 2008

Heh... 😛
Just a simple demonstration to show just how slow recursion can be. Let's populate a table with the number of 1 to 100,000... first method uses recursion... second...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 8:39 pm

#816917
RE: Connect for reporting services

Now... I DO have a question! Did I have to do all of that? I mean the part about making an exception in the XP firewall and all?...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 7:56 pm

#816913
RE: getdate() accuracy

Heh... LMAO!!! That's funny... RBARry Young... hadn't thought of that. :hehe:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 7:44 pm

#816911
RE: sum(),Cummulative addition,Case statement

rbarryyoung (5/17/2008)
Jeff, couldn't you use MAX(CAST(RestrictedID as int)) instead of SUM(SIGN(..))?
Absolutely... just didn't want to type that much 😛
Karthik, no function is required. The function is inherently RBAR in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 7:40 pm

#816910
RE: Connect for reporting services

It appears that I've got it... found the wonder "connection window" that allowed me to select the connection instead of typing the bloody connection information. The tutorial says to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 7:30 pm

#816909
RE: Connect for reporting services

I found this on Google:
http://littletalk.wordpress.com/2008/03/21/an-error-has-occurred-while-establishing-a-connection-to-the-server-when-connecting-to-sql-server-2005-this-failure-may-be-caused-by-the-fact-that-under-the-default-settings-sql-server-does-not-all/
I did the whole thing including the Firewall exceptions for MSSQL.1... I notice that I also have an MSSQL.2 and MSSQL.3... do I have to do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 7:07 pm

#816906
RE: Shrink Database

Shrinking database files that grow everyday is a futile thing to do to try to save space and fragments the heck out of the files on the OS.
Disk space is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 1:07 pm

#816890
RE: help with duplicates delete please

... like this...
SELECT d.*
INTO new_table_name
FROM (--=== Michael's subquery with a slight mod
select min(RecordId)
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 1:03 pm

#816889
RE: help with duplicates delete please

george sibbald (5/17/2008)
thankyou both.
Just to re-cap Jeff, you reckon best option to use Michaels subquery to select out to a new table, and will be faster than the delete? That...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 12:57 pm

#816888
RE: Accidental FANTASTIC discovery with UNPIVOT Operator

Wonderful job, Brandie... it's great! You should have submitted this as an article! 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 17, 2008 at 12:51 pm

#816886

Viewing 15 posts - 50,476 through 50,490 (of 59,099 total)