Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,621 through 31,635 (of 59,099 total)

RE: Red Gate Software announces DBA in Space competition winner

Whether you actually use the money for a space trip or not, congratulations for answering all of the questions and the rigors of both a public vote and judgement by...
--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)

December 21, 2011 at 8:17 pm

#1424546
RE: Does a SQL backup write tot he transaction log file?

Gosh... I think the backup and the log file growing don't have a thing to do with each other. I think someone had a bit of a problem with...
--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)

December 20, 2011 at 11:14 pm

#1424016
RE: Random Slowness in Insert statment

Normal blocking, I would say. What does the table you're inserting into look like and which column is the clustered index on? Also, what do the other indexes look...
--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)

December 20, 2011 at 11:08 pm

#1424014
RE: Random Slowness in Insert operation

~~Normal blocking, I would say. What does the table you're inserting into look like and which column is the clustered index on?~~
Sorry... posted at the same time as Jason......
--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)

December 20, 2011 at 11:05 pm

#1424011
RE: Date Range in Ms sql

margieleneespanol (12/20/2011)
How can I display a result with given date range.
I need a syntax for it.
Thanks
:crazy:
Provided the start and end of the date range are both expressed in "whole" dates...
...
--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)

December 20, 2011 at 10:57 pm

#1424006
RE: Date Range in Ms sql

Dev (12/20/2011)
For More: http://msdn.microsoft.com/en-us/library/ms187922.aspx
Oh, do be careful here. BETWEEN can lead to some really incorrect answers if dates with times are present in the data.
--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)

December 20, 2011 at 10:53 pm

#1424003
RE: where does that estimated number come from?

The OPTION(FAST 5) is probably responsible for the estimated rowcount of 5.
--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)

December 20, 2011 at 10:45 pm

#1423999
RE: Your Boss Is Your Customer

Gosh, Andy. Although I appreciate where you're going in these articles, that's, what? 4 in a row about how to be a better employee? Let's hear about...
--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)

December 20, 2011 at 10:39 pm

#1423998
RE: Are the posted questions getting worse?

L' Eomot Inversé (12/20/2011)
It's nice to see the old stuff turning up again, though. 🙂
That's why I'm here... ummm... wait... you weren't talking about me, were 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)

December 20, 2011 at 10:30 pm

#1423996
RE: Pride and Security

Absolutely wonderful article, Steve.
Concerning the question in the article...
If you had more pride in your employer, wouldn't you be a little more careful in caring for the company and its...
--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)

December 20, 2011 at 10:02 pm

#1423993
RE: Date with Time

SQLKnowItAll (12/20/2011)
Faster:
SELECT CAST(DATEDIFF(d,0,GETDATE()) AS DATETIME)
Can't find the article offhand that proves this, but I will continue to look. Could it be one of Jeff's?
I can't take the credit for...
--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)

December 20, 2011 at 8:15 pm

#1423986
RE: How to have an element and an attribute value in a tag

Brent Seeney-273128 (12/20/2011)
Hi Guys
I was using SQL Manager from EMS rather than SQL Server Management Studio, and it turns out that they give different outputs.
I had been so confounded by...
--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)

December 20, 2011 at 7:57 pm

#1423984
RE: Export to destination file - multiple rows to one

Sergiy (12/20/2011)
Or read this article:
http://www.sqlservercentral.com/articles/Test+Data/61572/
It's from the same author, so should be as useful.
🙂
Check the outcome generated in The "Hog" Test.
Just export 2 columns generated by the query to comma...
--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)

December 20, 2011 at 7:39 pm

#1423983
RE: Populate Start and End Time from Previous End Time

Hi Mattie,
Thank you for the very nice feedback and for posting your code.
Nope. @RowCounter doesn't keep things from "going into a loop". @RowCounter makes sure that the order...
--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)

December 20, 2011 at 7:14 pm

#1423981
RE: Get file size

Thanks, Hai.
--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)

December 20, 2011 at 6:59 pm

#1423979

Viewing 15 posts - 31,621 through 31,635 (of 59,099 total)