Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,146 through 23,160 (of 59,102 total)

RE: 1 Quick question for all the DBA's

New Born DBA (7/21/2014)
... there are days I just sit on my desk and pretty much read.
Read about what? If it's not about SQL Server, T-SQL, or setting up...
--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)

July 21, 2014 at 8:44 pm

#1731290
RE: How to run a SQL job using different account.

Mac1986 (7/21/2014)
I created a job with a step which has OperatingSystem(CMDEXEC) and run as DOMAIN\MYACCOUNT.
SQLCMD -q "SQLOPSDB.DBO.sp_now"
But now the job is not finishing as the above command does...
--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)

July 21, 2014 at 8:12 pm

#1731288
RE: Index grows really fast!

murnilim9 (7/21/2014)
twin.devil (7/21/2014)
If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your...
--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)

July 21, 2014 at 8:08 pm

#1731286
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
as I suspect if the EOF was recognized by bulk insert, I compare the two data files (the larger file costs me long time to load and even longer...
--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)

July 21, 2014 at 8:01 pm

#1731285
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
I found the root cause to the error, there is nothing wrong with you code but in fact when I save the format file, the UltraEdit automatically added some...
--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)

July 21, 2014 at 7:58 pm

#1731284
RE: Generate script to restore log backups

Michael Valentine Jones (7/21/2014)
I'm sure you really meant that a diff is a duplication of every page in the database that is new or changed since the last full backup,...
--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)

July 21, 2014 at 5:38 pm

#1731265
RE: Extracting VarBinary(MAX) column to Flat File - Facing Issue.

Try NOT using references to Unicode when dealing with binary data, which is no where near being Unicode.
--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)

July 21, 2014 at 5:14 pm

#1731263
RE: Insert sequence number

adonetok (7/21/2014)
I use
select max(sequence)
to find out max sequence number
I have to admit, I cringe a little every time I see a recommendation like that. There's just too...
--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)

July 21, 2014 at 5:08 pm

#1731262
RE: What would your answer be for this question?

The question ends with the following...
List 3 other areas to look for optimization opportunities. (Personal experiences are preferred over hypothetical scenarios). "
My answer would be...
Based on nearly 20 years...
--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)

July 21, 2014 at 4:59 pm

#1731260
RE: How to efficiently import data in .rpt format into SQL 2008

Ok... here we go...
The first thing that I did was to download your data import file and save it to my local machine at C:\Temp\Test.txt.
The next thing I did was...
--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)

July 21, 2014 at 3:59 pm

#1731243
RE: need help parsing XML

This is a duplicate post, which only serves to split up the answers. I recommend that no other answers be posted here. Instead, please see the original post...
--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)

July 21, 2014 at 2:23 pm

#1731214
RE: Need Help parsing through the XML

Eirikur Eiriksson (7/21/2014)
Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are...
--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)

July 21, 2014 at 2:14 pm

#1731209
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
Jeff Moden (7/21/2014)
Ok... I took the time to find your BCP format file and the example text file. This is easy. All the columns need to be...
--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)

July 21, 2014 at 2:09 pm

#1731205
RE: Generate script to restore log backups

SQLRNNR (7/21/2014)
Jeff Moden (7/21/2014)
Jack Corbett (7/21/2014)
SQLRNNR (7/21/2014)
I am a bit surprised this hasn't been asked yet and it seems REALLY important.
Why do you have 2000 log backups to...
--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)

July 21, 2014 at 12:32 pm

#1731164
RE: format the output column in destination .csv

Ah, my apologies. You said that in your original post and I was in too much of a hurry. I'm not sure how to do this on 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)

July 21, 2014 at 12:24 pm

#1731158

Viewing 15 posts - 23,146 through 23,160 (of 59,102 total)