Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,281 through 32,295 (of 59,099 total)

RE: Inserting into large table

Aspet Golestanian Namagerdi (10/15/2011)
I created a loop like (This is how it runs in productions,in a loop the SP is being called):
DECLARE @Temp AS INTEGER
SET @Temp = 1
WHILE @Temp <1000
Begin
...
--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)

October 15, 2011 at 12:03 pm

#1394980
RE: Are the posted questions getting worse?

Ninja's_RGR'us (10/14/2011)
Brandie Tarvin (10/14/2011)
Why is Remi's screen shot showing my numbers up top instead of his?
Or is there something in the code that makes even a screen shot show each...
--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)

October 15, 2011 at 11:49 am

#1394978
RE: Typical DBA day...

Ninja's_RGR'us (10/14/2011)
Is [font="Arial Black"]that [/font]why you stopped being a manager and went back to "normal" DBA?
Considering I covered several different topics in my post, is WHAT why?
--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)

October 15, 2011 at 11:45 am

#1394977
RE: I cringe every time I see a recommendation for xp_cmdshell.

rmechaber (10/14/2011)
In fact, when I searched on my machines for code or files containing "xp_cmdshell" I only turned up some demo scripts and this item: "8. Calls to xp_CmdShell 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)

October 14, 2011 at 10:06 am

#1394745
RE: EXEC xp_cmdshell error : the system cannot find the drive specified

It may not be a permissions issue... You also have to remember that xp_CmdShell will NOT find "mapped drives" using drive letters... only physical drives. Instead of mapped drives,...
--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)

October 14, 2011 at 9:16 am

#1394707
RE: Reverse Treeview

To add to ChrisM's code, please see the following article on how to display smaller hierarchies likes this...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--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)

October 14, 2011 at 9:09 am

#1394697
RE: convert date in sql

Brandie Tarvin (10/14/2011)
Performace Guard (Shehap) (10/14/2011)
Guys, please feel free to have a tour through different date time converstion per the link below :
http://www.sqlusa.com/bestpractices/datetimeconversion/
Wow. That website is completely unreadable and horribly...
--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)

October 14, 2011 at 8:50 am

#1394682
RE: convert date in sql

R.P.Rozema (10/14/2011)
The opening post seemed to ask for a string to datetime conversion. However as was clarified only recently, poster was actually looking for a conversion from datetime into 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)

October 14, 2011 at 8:43 am

#1394678
RE: I cringe every time I see a recommendation for xp_cmdshell.

@opc.three,
What's funny about all of this is that xp_DirTree, xp_CmdShell, xp_FileExists, etc, etc, etc all live in a single DLL called XPSTAR.DLL. Why they didn't take it just one...
--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)

October 14, 2011 at 12:55 am

#1394461
RE: File List ??

I know it's an old post but right, back in SAQL Server 2000, if you right clicked on an extended sproc and told it to execute, the number of parameters...
--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)

October 13, 2011 at 9:48 pm

#1394437
RE: Is xp_cmdshell Security threat???

sturner (6/22/2009)
It is really only dangerous in the case where appropriate and strict adherence to minimum required permissions and complex password safeguards are lacking or non-existent. Unfortunately this is true...
--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)

October 13, 2011 at 9:43 pm

#1394435
RE: GRANT EXECUTE returns 'mssqlsystemresource' does not exist

SQLRNNR (6/28/2011)
opc.three (6/28/2011)
SQLRNNR (6/28/2011)
Here's an article discussing the steps referenced by opc.three
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
Thanks Jason, I will keep this one to pass along, at least until Jeff publishes his article on how...
--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)

October 13, 2011 at 9:36 pm

#1394434
RE: Is table variable stored in tempdb?

Teemo (10/13/2011)
hello guys,
Is it true that when you created a table variable, and inserted a data on that table variable all stored on tempdb? same as temp table(#table)?
thanks in advance
Yes......
--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)

October 13, 2011 at 9:09 pm

#1394431
RE: How to remove old SQL Server Backup Files (.bak) within a script

Agh! Apologies, Perry. I didn't scroll down far enough to see your previous answer.
--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)

October 13, 2011 at 8:11 pm

#1394424
RE: How to remove old SQL Server Backup Files (.bak) within a script

Perry Whittle (10/13/2011)
i use a simple VBScript to prune files
Option Explicit
'Delete all SQL Server backup files more than x days old
Dim oFS, oSQLBackupFol, oFol, oFil
Set oFS = CreateObject("Scripting.FileSystemObject")
Set oSQLBackupFol =...
--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)

October 13, 2011 at 8:10 pm

#1394423

Viewing 15 posts - 32,281 through 32,295 (of 59,099 total)