Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,616 through 33,630 (of 59,099 total)

RE: Automation of Creating Trigger on All User Databases

My recommendation, at this point, would be to write the trigger you want for one database and post it. We'll help you write code to distribute it to a...
--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)

June 17, 2011 at 4:10 am

#1340277
RE: Automation of Creating Trigger on All User Databases

chelta (6/16/2011)
Hi All,
Ideally we want to be able to 'pick' what databases its installed on and automate it. There may be new user databases created that we dont want 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)

June 17, 2011 at 4:04 am

#1340271
RE: Degrading Service Performance Over Time

Leo.Miller (6/16/2011)
What about chached query plans? These are cleared on startup, could the cached plan no longer be effective? Have you tried doing a DBCC FREEPROCCACHE and seeing how things...
--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)

June 16, 2011 at 10:12 pm

#1340179
RE: request for syntax

andersg98 (6/16/2011)
I recall figuring out that somewhere around 20 characters is the breakeven point. Less than that and varchar is using more space keeping track of the offset 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)

June 16, 2011 at 10:04 pm

#1340175
RE: Select Tree and Order by from another table

Crud. I knew this looked all too familiar. We have a process at work that I developed to do something very, very similar and there's a patent pending...
--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)

June 16, 2011 at 9:38 pm

#1340169
RE: Select Tree and Order by from another table

Ok... I've got it. It'll take me a bit to modify the code.
--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)

June 16, 2011 at 8:12 pm

#1340163
RE: Select Tree and Order by from another table

nguyennd (6/16/2011)
Hi Jeff Moden.
I'm remove *, from the code and result is:
A
--A1
----A1.1
------Item Code = 3
--A2
----A2.1
------Item Code = 1
----A2.2
------Item Code = 2
--A3
B
C
But i need result is:
A
--A2
----A2.1
------Item Code = 1
----A2.2
------Item Code =...
--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)

June 16, 2011 at 7:57 pm

#1340157
RE: Inserting into an Table with Identity Column from n number of tables

Ok... will the real "Jayanth_Kurup" please stand up? Why two separate logins or are there really two people with the same name on this thread?
--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)

June 16, 2011 at 7:35 pm

#1340155
RE: how to check if SQL Server is running or NOT

Shamshad Ali (6/17/2009)
I think there is another way to check it if its working or not. Sometime ago i read that in a forum and i forgot to save 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)

June 16, 2011 at 7:32 pm

#1340153
RE: One procedure to insertupdate all master tables using if statements

opc.three (6/16/2011)
While your manager is outside the box ask him/her to consider what will happen when two people need to modify "The Proc"...one to change how Lady GaGa does her...
--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)

June 16, 2011 at 7:25 pm

#1340150
RE: Select Tree and Order by from another table

opc.three (6/16/2011)
Jeff Moden (6/16/2011)
You didn't read the entire post! 😉 I told you how to get that. Just remove the "*," from the code. 😉
Nice...and with 2 minutes...
--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)

June 16, 2011 at 5:21 pm

#1340131
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/16/2011)
No.
How's that for short, sweet and accurate? 😉
That absolutely works for me. 😀 It would be very cool if you told me what you use instead. 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)

June 16, 2011 at 5:19 pm

#1340130
RE: Finding dates in Dates tally table

opc.three (6/16/2011)
Thanks gents Writing? Love to try my hand at it but do not know where to start. I sent you an email.
Got the email. Working on a...
--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)

June 16, 2011 at 5:14 pm

#1340129
RE: Finding dates in Dates tally table

tfifield (6/16/2011)
Jeff Moden (6/14/2011)
I also thought that opc.three's addition of an instance column was brilliant. I've never had a business case for that, but I'm putting it my tool...
--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)

June 16, 2011 at 5:13 pm

#1340128
RE: Ussing Substring, Patindex, Charindex to extract data from a string

C'mon back if the article doesn't do it for you. I coud write the code for you but I'd just be copying it from my own article and then...
--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)

June 16, 2011 at 7:27 am

#1339682

Viewing 15 posts - 33,616 through 33,630 (of 59,099 total)