Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,481 through 30,495 (of 59,101 total)

RE: Bye Bye to the RAISERROR Function?

By default, the Throw statement always has the severity of 16.
Microsoft deprecates yet another incredibly useful tool and replaces it with a piece of garbage with much fewer capabilities. ...
--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 3, 2012 at 5:22 am

#1468132
RE: Subtotals in t-sql

gmcnitt (4/2/2012)
Both work, but yes, improved.....now I just need to spend the time to figure it all out....:-)
BTW, it works perfect on my 20,000 + rows, took 7 seconds total.....
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)

April 2, 2012 at 7:02 pm

#1467986
RE: Subtotals in t-sql

Heh... I just knew that would be the next question and I should have done that to begin with.
SELECT PIN = ISNULL(PIN,''),
...
--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 2, 2012 at 6:53 pm

#1467982
RE: Subtotals in t-sql

You can do this with fewer table scans, without an additional temp table, and in such a fashion that you could actually turn it into a "reporting" view.
SELECT *
...
--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 2, 2012 at 5:22 pm

#1467965
RE: How to get all rows of a table having NULL in all columns?

dwain.c (4/1/2012)
Perhaps one of these is the shorthand the OP is looking for?
Select *
from TEST
where ISNULL(Col1,'')+ISNULL(Col2,'')+ISNULL(Col3,'')+ISNULL(Col4,'') = ''
Select *
from TEST
where COALESCE(Col1,Col2,Col3,Col4) IS NULL
Could it be 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 2, 2012 at 5:12 am

#1467568
RE: load data and foreign keys

opc.three (3/30/2012)
Z1024 (3/30/2012)
opc.three (3/30/2012)
Z1024 (3/29/2012)
For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows...
--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 1, 2012 at 7:20 pm

#1467468
RE: How to get all rows of a table having NULL in all columns?

I stand corrected. Thanks, Tom.
--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 1, 2012 at 3:25 pm

#1467462
RE: Auto Increment

SPAM reported.
--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 1, 2012 at 2:26 pm

#1467457
RE: Do not want to use a cursor but how.....

jeffrey.farr (3/30/2012)
Since each of the '<>' is an event, that would be ideal.
Like my post indicated I just need the event and the Alarm Time.
And thank you for your assistance.
Sorry,...
--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 1, 2012 at 11:16 am

#1467448
RE: Staging Tables do not contain a DateTime Stamp or Source System, etc.

Not having the Enterprise Edition might not be a showstopper. Partitioned views can be almost as effective if you can create the right constraint that each table would require...
--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 1, 2012 at 8:56 am

#1467428
RE: Staging Tables do not contain a DateTime Stamp or Source System, etc.

Welsh Corgi (3/31/2012)
Load times are slow because we have to deal with linked servers (which oly have PK's).
If that's the case, wouldn't it be better if they exported 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)

April 1, 2012 at 7:51 am

#1467417
RE: Staging Tables do not contain a DateTime Stamp or Source System, etc.

The most common practice the I've personally seen is to load Staging tables in whatever the "format" of the original file is and then do what's necessary to get them...
--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 1, 2012 at 7:49 am

#1467415
RE: How to get all rows of a table having NULL in all columns?

CELKO (3/31/2012)
This is impossible because the key columns cannot be NULLs.
Agreed. That's why I initially forgot about the technique. The entire row must be blank for the CHECKSUM(*)...
--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 1, 2012 at 7:33 am

#1467412
RE: syntax error

SQLRNNR (3/30/2012)
Please post all replies to the initial thread:
http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx
According to that link, Jason... we're already there. 😉
--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)

March 31, 2012 at 4:23 pm

#1467357
RE: Data tuning in SQL 2005

mukund.bklwh (3/31/2012)
Sir/s,
I'm using SQL 2005 and our Database size is 6.18 GB now and currently I'm facing problem of Timeout expired. Any quick tool which can release me from 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)

March 31, 2012 at 3:58 pm

#1467354

Viewing 15 posts - 30,481 through 30,495 (of 59,101 total)