Jeff Moden

Forum Replies Created

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

RE: Creating and Dropping a View

Mybowlcut (5/18/2008)
Why do you need to do this? It may make a difference...
What do you mean? It's part of an assignment. Please don't say this is a "homework question"...
--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 19, 2008 at 4:49 am

#817071
RE: Querying Same Number of Rows in 2 tables

The question you asked was why was the copy/query to a heap so much faster... I answered that. If you put the index on the original table that Lynn...
--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 6:22 pm

#817057
RE: A Simple Mistake

Anirban Paul (5/14/2008)
Readability comes from indentation and usage of space not from smaller case or capital case.
Just for the record, I strongly disagree with that and that's why I...
--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 5:40 pm

#817055
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

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