Forum Replies Created
Viewing 15 posts - 43,906 through 43,920 (of 59,101 total)
-
RE: Mining for Experts
Heh... I learned a great East Indian word for the techniques used to find experts... ready? "Booils**t".
I'm currently 4 for 4... That is, I've worked with 4...
--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) -
RE: Quarterly Executive Reports
tdunbar (5/4/2009)
I have a request from my manager to produce quarterly reports. There was not a lot of specific when I asked about expectations or purpose of the report.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) -
RE: I've tried this on 2 other forums, does anyone know the answer?
Steve Jones - Editor (5/4/2009)
I'd still vote for 13 separate databases, and turn Barry's comment around. It's harder than one database, but not 13x harder. Just a little harder.Heh... and...
--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) -
RE: Using Functions or Stored Procedures or Views or ????
Like Grant said... "Just to pile it on"...
I agree with what the others have said. While the use of UDF's can make for some very RAD (Rapid Application Development)...
--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) -
RE: Creating New Databases on SQL 2005 best practices
kevball2 (5/4/2009)
I have a quick question on new DB creation, our SQL DBA's are wanting to use the SA account to create new DB's for the SQL 2005 cluster. 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) -
RE: delete then dropTruncate then drop/just drop
Here's the same tests but in the FULL recovery mode. Just DROP wins again... notice the couple of writes to the log this time...
--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) -
RE: delete then dropTruncate then drop/just drop
I agree with George. Just to be sure, though, I ran a test where I build my normal million row test table and then used profiler to measure what's...
--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) -
RE: Read from Text file
Like Jackie Chan's Uncle says... "And one more thing..."
If the second operand evaluates to "0" (zero), you get the whole directory structure from the current directory mentioned in the first...
--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) -
RE: Read from Text file
Jeff Moden (5/4/2009)
psteja2000 (5/4/2009)
I ended up hacking what I wanted from here:http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/
Not bad... just be advised that there is absolutely no need to resort to the likes of xp_CmdShell or...
--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) -
RE: Read from Text file
Jack Corbett (5/4/2009)
Jeff Moden (5/4/2009)
Ramesh (5/4/2009)
I would go with SSIS and the following link should get to startedhttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
Not a bad recommendation... I just do it all from T-SQL. 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) -
RE: Read from Text file
psteja2000 (5/4/2009)
I ended up hacking what I wanted from here:http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/
Not bad... just be advised that there is absolutely no need to resort to the likes of xp_CmdShell or the horribly...
--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) -
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S
Manie Verster (5/4/2009)
gserdijn (5/1/2009)
Manie Verster (4/30/2009) Here is a cursor that I would like you to convert to set for me please. If you can do this I will accept...
--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) -
RE: Filtered index with IS NULL predicate
Sheng (5/3/2009)
Jeff Moden (5/3/2009)
In that case, I'd recommend that you remove the index hint and add the proper index as a covering index instead of what you currently have as...--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) -
RE: Read from Text file
Ramesh (5/4/2009)
I would go with SSIS and the following link should get to startedhttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
Not a bad recommendation... I just do it all from T-SQL. I hope to never learn...
--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) -
RE: Recursive query for a Bill of Materials table
New uses of something "old" is never a bore. Thank you for the feedback even on old threads.
--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)
Viewing 15 posts - 43,906 through 43,920 (of 59,101 total)