Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,876 through 22,890 (of 59,102 total)

RE: Are the posted questions getting worse?

Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:
In more than one thread. :Whistling:
Heh... they should just add him to the spammer's list except, in his case,...
--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)

August 24, 2014 at 9:39 pm

#1740615
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/22/2014)
Finally, things are working. A debug item slipped through into production (apparently).
Let me know if things are still broken.
So far, so good. Thanks 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)

August 24, 2014 at 9:37 pm

#1740614
RE: I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE HELP ME HOW TO WRITE

Steve Jones - SSC Editor (8/24/2014)
Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).
You don't want to do this 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)

August 24, 2014 at 9:30 pm

#1740612
RE: Query Help

JackTimber (8/24/2014)
Eirikur Eiriksson (8/23/2014)
Shadab Shah (8/23/2014)
Hi Eirikur,
I have being trying to help OP with this question with the help of your solution.
I think the grouping in your solution is incorrect.
If...
--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)

August 24, 2014 at 9:25 pm

#1740610
RE: Query Help

Eirikur Eiriksson (8/24/2014)
Jeff Moden (8/23/2014)
That's some very nice modularized code.
I am striving to maintain the readability of my code;-)
My concern at this point would be the 4 table scans...
--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)

August 24, 2014 at 9:24 pm

#1740608
RE: Query Help

Eirikur Eiriksson (8/23/2014)
Shadab Shah (8/23/2014)
Hi Eirikur,
I have being trying to help OP with this question with the help of your solution.
I think the grouping in your solution is incorrect.
If we...
--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)

August 23, 2014 at 8:45 pm

#1740529
RE: Question regarding the difference between two different ways to populate a new table in TSQL

BTW, for anyone interested but especially for Cathy...
The following two articles explain the basics of how to quickly and easily build a million rows of test data and the resulting...
--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)

August 23, 2014 at 3:18 pm

#1740511
RE: Question regarding the difference between two different ways to populate a new table in TSQL

Sean Lange (8/22/2014)
There is no valid reason that one is preferred over the other.
Actually, there is 😀 ... the first code is both shorter to write and easier 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)

August 23, 2014 at 3:11 pm

#1740509
RE: Question regarding the difference between two different ways to populate a new table in TSQL

ChrisM@Work (8/22/2014)
Cathy DePaolo (8/22/2014)
I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve performance...
--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)

August 23, 2014 at 3:09 pm

#1740508
RE: Question regarding the difference between two different ways to populate a new table in TSQL

Cathy DePaolo (8/22/2014)
I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve performance of...
--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)

August 23, 2014 at 2:53 pm

#1740505
RE: Prevent ALTER VIEW on indexed view

Jack Corbett (8/22/2014)
DennisPost (8/22/2014)
Resolved.
Daily job saves all indexed views into a table.
DDL trigger checks if the view to be alter is in the IndexedView table.
If so, raise error...
--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)

August 22, 2014 at 3:03 pm

#1740416
RE: SQL Server US Contracting Rates

Gosh. Don't play games. You'll get a bad rep with the agencies and never get work.
Figure out what you're worth and ask that amount with the understanding 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)

August 22, 2014 at 8:15 am

#1740246
RE: Query execution not showing up in profiler trace

Add % before and after the filter in the trace, as well.
--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)

August 22, 2014 at 8:09 am

#1740244
RE: Scalar Function - SYSDATETIME() as default parameter.

Koen Verbeeck (8/22/2014)
Found it 😀
Apparently default values for parameters need to be constants, not other functions.
http://stackoverflow.com/questions/470664/sql-function-as-default-parameter-value
Boohoo SQL Server.
I'm sure it's obvious to you but, in case anyone else reads this,...
--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)

August 22, 2014 at 7:57 am

#1740237
RE: SQL Database is corrupted....... plz help.

If you don't actually have a good backup (shame on you), perhaps there's some hope. In no way, shape, or form is this an endorsement of any kind because...
--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)

August 22, 2014 at 7:28 am

#1740211

Viewing 15 posts - 22,876 through 22,890 (of 59,102 total)