Jeff Moden

Forum Replies Created

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

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
RE: Common questions asked in SQL Server DBA Interview

Randheer (2/25/2014)
Check out below link for Interview Questions and answers for SQL Server DBA
http://www.sqlserverquest.com/p/sql-server-dba-interview-questions.html
The link didn't work even when I copied and pasted it. 😉 I did, however,...
--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:25 pm

#1703550
RE: Getting Started in SQL Server

Evil Kraig F (10/28/2011)
I figure I'm about average for most DBA/Devs in ability, time availabily, and desire.
I'm glad they republished this article. Very well written, Craig.
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 6:04 pm

#1703549
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

There is one scenario where what you claim is true but, from what I can see, it's only for a "no rows found" condition. Here's the code...
PRINT...
--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 5:38 pm

#1703548

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