Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,961 through 24,975 (of 59,099 total)

RE: There is insufficient system memory in resource pool 'default' to run this query

krishnamohan6669 (1/1/2014)
and now it is repeatedly occuring every week.
So, what is running at that time "every week"? I ask because I'm thinking the "top" symptom of not having enough...
--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)

January 1, 2014 at 11:14 am

#1676739
RE: drop clustered index ,rebuild or reorganize non clustered index?

sql crazy kid (1/1/2014)
Jeff Moden (1/1/2014)
sql crazy kid (12/31/2013)
If i drop a clustered index from table, how the non clustered behave when this is on same table.
Will all the non...
--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)

January 1, 2014 at 10:23 am

#1676738
RE: Double quotes on Bulk Insert

Luis Cazares (1/1/2014)
Thank you for all of your recommendations. I will try all of them (I might not be able to use the error file because of permissions to write...
--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)

January 1, 2014 at 10:13 am

#1676734
RE: drop clustered index ,rebuild or reorganize non clustered index?

sql crazy kid (12/31/2013)
If i drop a clustered index from table, how the non clustered behave when this is on same table.
Will all the non clustered index drop and recreate?...
--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)

January 1, 2014 at 12:34 am

#1676707
RE: Rebuilding Indexes very often is good?

Andrew Andrews (12/31/2013)
Some food for thought...There is a great video discussing why you generally should NOT worry about fragmentation. Instead, you should set fill factor to 100 and try 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)

January 1, 2014 at 12:05 am

#1676705
RE: Bulk Insert (0 row(s) affected)

BULK INSERT won't import spreadsheet files. You need to export the data from the spreadsheet into a TAB or COMMA delimited text file and then BULK INSERT 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)

December 31, 2013 at 11:04 pm

#1676704
RE: Will this work for deleteing a large number of rows?

jasona.work (12/9/2013)
Ed,
On #1, absolutely! This is why there's a QA environment as well. I've actually been developing the code against the QA DB / table.
On #2, I'd forgotten...
--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)

December 31, 2013 at 10:57 pm

#1676703
RE: How to split the date format into month with year?

Lynn Pettis (12/31/2013)
Assuming this is still true: billed_date datetime
right('0' + cast(month(billed_date) as varchar(2)),2) + '-' + cast(year(billed_date) as varchar(4))
... or...
SELECT RIGHT(CONVERT(CHAR(10),GETDATE(),105),7)
--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)

December 31, 2013 at 10:13 pm

#1676702
RE: Stop/Start SQL Server Agent

JohnFTamburo (12/31/2013)
Jeff Moden (12/31/2013)
What about DBAs using it to elevate their privs as you have just done? It's not the usage of xp_CmdShell that caused that risk. It's...
--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)

December 31, 2013 at 10:02 pm

#1676701
RE: Exclude Columns When Using Bulk Insert

Cool... Thanks for the feedback.
--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)

December 31, 2013 at 9:05 pm

#1676700
RE: Double quotes on Bulk Insert

As a bit of a sidebar, I've been looking at your format file and have a couple of suggestions.
First, the XML format requires that you set the length in both...
--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)

December 31, 2013 at 8:47 pm

#1676698
RE: Double quotes on Bulk Insert

Crud. My apologies. I misread the question.
Yes, you could use a staging table. That way you can do an update to "singularize" the embedded double quotes and...
--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)

December 31, 2013 at 7:42 pm

#1676695
RE: How yo make these two queires to one please

Christian Graus (12/31/2013)
I feel sorry that I opened this can of worms, I'm not sure how much benefit there is in discussing it further. My very first post there,...
--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)

December 31, 2013 at 4:56 pm

#1676690
RE: Stop/Start SQL Server Agent

JohnFTamburo (12/31/2013)
(please disable xp_cmdshell as soon as you do this; it is a huge security hole)
No it's not. Poor ol' xp_CmdShell gets blamed for other very poor security practices...
--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)

December 31, 2013 at 4:42 pm

#1676686
RE: Index Tuning never finishes

rummings (11/24/2013)
I have been given several large databases to tune. They have never had the statistics updated and I cannot tell when the indexes were last rebuilt. I tried 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)

December 31, 2013 at 11:22 am

#1676652

Viewing 15 posts - 24,961 through 24,975 (of 59,099 total)