Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,856 through 21,870 (of 59,098 total)

RE: Are the posted questions getting worse?

Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If 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)

January 18, 2015 at 3:42 pm

#1771009
RE: temp DB is full

Any long running transaction that caused the explosion in TempDB has already been killed by the system error produced when TempDB ran out of space. The chores now will...
--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)

January 18, 2015 at 12:40 pm

#1771003
RE: display month wise data in sql server

asranantha (1/18/2015)
Hi Friends I have small doubt in sql server please tell me how to resolve this in sql server
Table data like below
id |month|stat|count
1 |1|admit|7
2 |8|admit|47
1 |7|admit|28
2...
--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)

January 18, 2015 at 12:34 pm

#1771001
RE: Insert Statement with IF Statement

Meatloaf (1/18/2015)
Is it possible to have an Insert Statement with an IF?
For example I want to check the value of a field upon insert. If the value 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)

January 18, 2015 at 12:29 pm

#1771000
RE: Please explain what this Trigger query does

P.S. I almost forgot... because Item #6 causes only one row to be inserted into the audit table during UPDATEs, it doubles the performance of UPDATEs. Because Item...
--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)

January 18, 2015 at 12:20 pm

#1770999
RE: Please explain what this Trigger query does

lawlietdba (1/17/2015)
Hi Jeff,
Thanks verymuch for your suggestion. As you said I found the separate triggers for Update as well as Delete . Please explain what can be done to improve...
--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)

January 18, 2015 at 11:40 am

#1770998
RE: Help With Trying to Import File Names into a Table

@Lemptster,
Outstanding! Thank you for the time you took on that. I especially appreciate the methods you talked about for the promotion of packages and projects.
Shifting to the subject...
--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)

January 17, 2015 at 5:56 pm

#1770970
RE: Where is the test?

gabgo (1/17/2015)
No, there is nothing at that URL...
Considering the link on that post, reported as SPAM.
--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)

January 17, 2015 at 11:46 am

#1770964
RE: what else can you search for instead of col1 = '' or col1 = ' ' or col1 is null?

TheSQLGuru (1/16/2015)
Butt, the paperwork is simple, although it can smear your reputation and cause quit a stink.
Jeff, that is SOOO over the top!! 😛
Heh... yeah, sorry. I really bottomed...
--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)

January 17, 2015 at 11:33 am

#1770963
RE: Please explain what this Trigger query does

Eirikur correctly described what the code in the trigger does. I'll tell you that the trigger uses older methods, can be improved a bit performance-wise, has unnecessary error handling,...
--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)

January 17, 2015 at 11:19 am

#1770962
RE: Help With Trying to Import File Names into a Table

Eirikur Eiriksson (1/17/2015)
Jeff Moden (1/17/2015)
To help wet my appetite for reading that stairway further, would someone please just tell me how to load the previously identified packages so that 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)

January 17, 2015 at 11:01 am

#1770955
RE: Help With Trying to Import File Names into a Table

Eirikur Eiriksson (1/17/2015)
Jeff Moden (1/16/2015)
Samuel Vella (1/16/2015)
Jeff Moden (1/15/2015)
No problem. Thank you very much for your efforts.
I have to admit that when it comes to SSIS, I get totally...
--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)

January 17, 2015 at 7:31 am

#1770951
RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

h.tobisch (1/16/2015)
PLEASE, could you, just in one sentence, tell the essence of what you are doing ?
Short circuit a query using a SARGable predicate to take advantage of the index...
--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)

January 16, 2015 at 7:39 pm

#1770934
RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

Hi Dwain,
Great article, as usual. It spawned some pretty good discussion, as well. Well done and thanks for taking the time to write something like this.
I did find...
--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)

January 16, 2015 at 7:38 pm

#1770933
RE: How to ignore "String or binary data would be truncated"

<Head-Desk> I'm obviously sleeping. I total missed the fact that the history table has an active IDENTITY column in it. The column offset by using 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)

January 16, 2015 at 7:08 pm

#1770932

Viewing 15 posts - 21,856 through 21,870 (of 59,098 total)