Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,941 through 23,955 (of 59,102 total)

RE: Unable to Kill Process :dbcc inputbuffer

Lynn Pettis (4/7/2014)
Almost a four year old thread.
BWAAA-HAAAA!!! (Sorry... did that come out loud?) 😛
--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, 2014 at 1:32 pm

#1703935
RE: Transpose data?

kwaldman 36287 (4/7/2014)
Hi all,
I'm new to SQL and these forums, but I'd love some help! I have a table that has data on drugs that people receive during hospital stays....
--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, 2014 at 1:30 pm

#1703933
RE: Help need in Avoiding Loop

born2achieve (4/7/2014)
Hi Jeff,
Quick Query about if i have 60000 + records to process with this logic will it break anywhere with timeout issue. could you please suggest me
It should run...
--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, 2014 at 1:26 pm

#1703929
RE: Find and Replace Injection String in Server 2005

allaspects (4/7/2014)
I was hoping for something a little clearer and more simplified. Unfortunately, most of my experience is in mysql and I'm not really a windows server person but 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)

April 7, 2014 at 11:13 am

#1703891
RE: mdf file growth - no inserts

Ryan Keast (4/7/2014)
Looks like it's linked to my Rebuild Index Task.
Everytime I run it - the database balloons in size.
Via the GUI I have the Change Free space per...
--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, 2014 at 11:06 am

#1703888
RE: trigger to audit

So if the original login name (Origininal_Login()) is the name of the app, just do a return in the trigger.
--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 6, 2014 at 5:12 pm

#1703610
RE: Short Stroking and Performance

Jim P. (4/5/2014)
So I was able to change performance from bad to abysmal to an acceptable level just from tuning.
Just curious... "tuning" what? Hardware, disks, code, indexes, ???, or...
--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 6, 2014 at 10:06 am

#1703591
RE: Processing flat file with Header,Detail and Trailer

naresh0407 (4/5/2014)
Hi..Actually are asked to validate this task without scripttask.We should use inbuilt transformations to achieve this task.Could you please tell me how can we acheive this.Just let me know...
--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 6, 2014 at 9:59 am

#1703589
RE: trigger to audit

J Livingston SQL (4/6/2014)
the following may help you on your way
/* create the audit table.
There will only need to be one of these in a database
...
--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 6, 2014 at 9:53 am

#1703588
RE: Format results as HTML table w/ powershell

Cody K (4/6/2014)
There is a really comprehensive cmdlet and tutorial that I use: http://gallery.technet.microsoft.com/scriptcenter/PowerShell-HTML-Notificatio-e1c5759d
Seeing as I don't think that can be beat, I'd like to offer an alternative 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)

April 6, 2014 at 8:42 am

#1703586
RE: simple store procedure

print concat('drop table ',@tablename);
I just can't help it. CONCAT seems so much less natural and less obvious and more difficult to read than...
print 'drop table ' + @tablename;
--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 5, 2014 at 7:29 pm

#1703556
RE: SQL Server 2005 (x64) Download

Cathal Walshe (4/5/2014)
Hi there
We are looking to upgrade from SQL 2005 32 bit to SQL 2005 64 bit
I cannot find a download link for SQL Server 2005 (x64) anywhere
Can anyone...
--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 5, 2014 at 7:26 pm

#1703555
RE: Format results as HTML table w/ powershell

Steve Jones - SSC Editor (1/31/2014)
It's easy, but a reference that shows beginners how we take some data, perhaps performance or other data in a query and export it as...
--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 5, 2014 at 7:02 pm

#1703554
RE: trigger to audit

Just to be sure, this wasn't a "wise guy" question that I posted above. I'd really like to know. 🙂
--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 5, 2014 at 6:59 pm

#1703552
RE: Get the hierarchy orders(top to bottom) of the table

yuvipoy (4/3/2014)
Jeff Moden (4/2/2014) my answer can only be to "lookup the ParentID in Table2 and use it to find the information in Table1".
Yes similarly kind fof information i need...
--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 5, 2014 at 6:41 pm

#1703551

Viewing 15 posts - 23,941 through 23,955 (of 59,102 total)