Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,516 through 22,530 (of 59,072 total)

RE: Alternative to xp_cmdshell

Gazareth (11/6/2014)
Powershell sounds good for this. You'll need to install SQLPS module, and then simply (NB - pseudocode):
Invoke-SqlCmd -ServerInstance servername -Database dbname -Query "EXEC proc" | Export-Csv filename.csv
or
Invoke-SqlCmd -ServerInstance servername...
--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)

November 6, 2014 at 6:42 am

#1756979
RE: Serial Date conversion

cbrammer1219 (11/4/2014)
This is what I have done, then I take that and do a DATEDIFF on the 2 values to get the seconds.
CONVERT(varchar(8),CONVERT(datetime,case
...
--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)

November 5, 2014 at 8:19 pm

#1756862
RE: Serial Date conversion

cbrammer1219 (11/4/2014)
Ok so no that I have that, I am looking to do a case so that if the value can be converted to minutes, hours or leave as seconds....
--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)

November 5, 2014 at 7:07 pm

#1756858
RE: Max Length of AD Names for Security

Having AD names longer than 20 characters is (from what I understand) only a display problem for things like NET GROUP and NET USER because they're leftovers from the old...
--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)

November 5, 2014 at 7:05 pm

#1756857
RE: Alternative to xp_cmdshell

Igor Micev (9/20/2014)
xp_cmdshell should be disabled from the security risk aspect. When you have xp_cmdshell enabled you're allowing processes outside sql server to do changes to databases.
I usually do...
--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)

November 5, 2014 at 7:00 pm

#1756856
RE: Quick health check / environment synopsis

Adam Bean (11/4/2014)
...however my current goal is more so to target performance.
Hi Adam,
Assuming that you're talking about the performance of SQL Server, I've found that most people look in the...
--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)

November 5, 2014 at 8:09 am

#1756761
RE: How to bulk insert (or another way) to SQL table from datatabel from inside store prcedure

Ed Wagner (11/4/2014)
Luis Cazares (11/4/2014)
There's a BULK INSERT command in SQL Server. You can read about it in here: http://msdn.microsoft.com/en-us/library/ms188365.aspx
To add functionality using format files, you can read the following...
--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)

November 5, 2014 at 6:42 am

#1756742
RE: Automating SQL Server Patching for 10000+ Instances.

Ok.... you've got my curiosity up. 10,000+ instances? Why so many?
And considering that the max number of instances you can have per machine is 50, 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)

November 5, 2014 at 6:39 am

#1756740
RE: Today's Random Word!

Ed Wagner (11/4/2014)
SQLRNNR (11/4/2014)
Pistol
Rifle
Porkchop Cannon 😀
--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)

November 4, 2014 at 4:42 pm

#1756638
RE: do you have a StripNonNumeric ITVF function?

Eirikur Eiriksson (11/4/2014)
Just dawned on me, kind of a deja vu, here is around six years old thread on the same subject.
😎
Heh... after 6 years, we might finally be on...
--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)

November 4, 2014 at 4:41 pm

#1756637
RE: Best way to validate telephone number

What is the [font="Arial Black"]BEST [/font]way? The answer is to follow the telephone number rules. For example, there is no area code that starts with 0 or 1....
--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)

November 3, 2014 at 5:50 pm

#1756433
RE: bulk insert question

Just be VERY aware that the rows you skip must have the exact same number and type of delimiters as the rows you want to import or you're in for...
--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)

November 2, 2014 at 5:05 pm

#1756242
RE: Best performance of database and queries

.Netter (11/1/2014)
Hello,
Say I have a table called orders which has about 40 columns, and could potentially grow to 100k + I have a primary key on that to query this...
--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)

November 2, 2014 at 4:31 pm

#1756238
RE: Can we backup all stored procedures in a database?

gary1 (10/31/2014)
Hi, is there a way to backup all stored procedures in a database?
Yes... have a look at the sys.sql_modules view. There's more than just Stored procedures there, 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)

October 31, 2014 at 7:44 pm

#1756163
RE: Partitioning and restoring to Standard Edition

JeepHound (10/31/2014)
I am restoring a 3rd party Vendor database from SQL2008R2 Enterprise to SQL2008R2 Standard. I get an error that I can't restore because there is a partition function....
--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 31, 2014 at 10:27 am

#1756092

Viewing 15 posts - 22,516 through 22,530 (of 59,072 total)