Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,971 through 38,985 (of 59,072 total)

RE: Who "Owns" the Database?

The "users" own the data but you must assume ownership enough to protect the data even from them. Heh... Perhaps a small poem I heard a long time ago...
--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)

April 7, 2010 at 8:09 pm

#1147968
RE: Have some question

lmu92 (4/7/2010)
GregoryF (4/7/2010)
I think you have gone way beyond the scope of someone who asked what the difference between delete and truncate is 🙂 Don't confuse them while they...
--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)

April 7, 2010 at 7:49 pm

#1147958
RE: Have some question

miss.delinda (4/7/2010)
I've question as follow,
1. How many types of temporary tables exist in SQL Server and how is each type symbolized?
2. What is the lifetime and visibility of each type?
3....
--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)

April 7, 2010 at 7:43 pm

#1147957
RE: How to fing first letter is a number or letter in a column

Jason Selburg (4/7/2010)
test for numeric:
ISNUMERIC(LEFT(yourFieldName,1)) = 1
Heh... you sure about that ol' friend?
SELECT ISNUMERIC(LEFT('$Howdy',1)),
ISNUMERIC(LEFT(',Howdy',1)),
...
--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)

April 7, 2010 at 7:25 pm

#1147955
RE: Data compression

Tara-1044200 (4/7/2010)
Can some one please let me know what is the exact % of data and backup files that compressess comparing it to 2005.
No because, just like a ZIP file,...
--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)

April 7, 2010 at 7:18 pm

#1147951
RE: How to add consecutive row values

gundan01 (4/7/2010)
Ahhhh!!! This actually is a good because I tried to used the other post with reporting services and I actually had to create a store procedure to use it...
--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)

April 7, 2010 at 7:09 pm

#1147950
RE: Date Manipulation with DATEADD/DATEDIFF

Nice done, Seth. Good clear article. Heh... it's funny how these things happen... I just got done demonstrating to the folks at work how VARCHAR conversions use twice...
--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)

April 7, 2010 at 6:48 pm

#1147945
RE: How many of you have done Certification for SQL Server?

ChrisMoix-87856 (4/7/2010)
...
but by point is that he was a certified DBA and because of that, felt entitled to work on our DBA team. Needless to say, we never...
--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)

April 7, 2010 at 6:31 pm

#1147935
RE: OPENROWSET to return an integer with parameters

robert-695083 (4/6/2010)
Seems you cant use Order By new() in a function unless it is in Dynamic sql. And the only way I could find to use it was in openrowset...Any...
--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)

April 7, 2010 at 6:18 pm

#1147930
RE: OPENROWSET to return an integer with parameters

bteraberry (4/6/2010)
NEWID() is to create a new unique identifier ... ordering by that function makes no sense to me. I would be curious to understand exactly what you're trying...
--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)

April 7, 2010 at 6:13 pm

#1147927
RE: Forum Etiquette: How to post data/code on a forum to get the best help

nicholas.bazin (4/7/2010)
Hey,
I'm quite new to the forum and I greatly appreciate this article.
Much thanks for posting it.
You bet. Thanks for stopping by and thanks for the feedback.
--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)

April 7, 2010 at 5:49 pm

#1147915
RE: Creating Indices on Temp Tables from Stored Procedures

kramaswamy (4/6/2010)
I think that it could be an interesting summer job for an intern,...
Heh... summer intern evaluating code for performance problems. I believe that probably won't help.
...because you're...
--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)

April 7, 2010 at 5:46 pm

#1147913
RE: FizzBuzz

CirquedeSQLeil (4/7/2010)
You know, it is article worthy. I would like to see an article on what made you decide to implement that method and performance factors etc.
I believe 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)

April 7, 2010 at 5:16 pm

#1147886
RE: FizzBuzz

Gianluca Sartori (4/7/2010)
CirquedeSQLeil (4/6/2010)
Jeff Moden (4/6/2010)
Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631
It seemed to perform the fastest on...
--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)

April 7, 2010 at 3:00 pm

#1147792
RE: FizzBuzz

Steve Jones - Editor (4/7/2010)
Jeff Moden (4/6/2010)
Dunno if it's possible, Steve, but I think both Gianluca and the one with the most votes by March 31st should be thrown the...
--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)

April 7, 2010 at 2:57 pm

#1147788

Viewing 15 posts - 38,971 through 38,985 (of 59,072 total)