Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,041 through 32,055 (of 59,099 total)

RE: Searching smallest unused number

Heh... now do some testing where no numbers are missing and see the other side of this story. 😉
--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, 2011 at 9:37 pm

#1403575
RE: Data import

Are you saying that you want to give, say, a stored procedure just a table name and have the stored procedure generate the XML for the data in the entire...
--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, 2011 at 8:55 pm

#1403573
RE: Starting with "WITH"

L' Eomot Inversé (11/3/2011)
There's nothing in recursion that prevents set-based description.
If you take a look at the "Reads" chart in the article I provided a link for in my previous...
--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, 2011 at 8:52 pm

#1403572
RE: Starting with "WITH"

RowanCollum (11/3/2011)
Suckishly? ¿Por qué? I've seen otherwise, but, I'm curious to know the instances where CTEs have performed poorly.
Coming right up! 😉 Please see the article at...
--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, 2011 at 8:49 pm

#1403571
RE: how to get filename of latest file in a directory with t/sql?

sqlguy-736318 (11/3/2011)
I'm in the process of creating a database restore script for my staging server.
Whenever I restore a database on my staging server I always restore a bak file with...
--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, 2011 at 8:41 pm

#1403570
RE: How we can Improve the Performance of a Query WIthout creating Indexes

sarvade.inder (11/4/2011)
Hi John,
I dont have permission to create Index.
In Execution plan its giving Table Scan only..
what are the other way's to improve the performance of the query?
To add 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)

November 4, 2011 at 8:29 pm

#1403569
RE: SQL Server maximum server memory setting and tempdb behaviour

cbr78rr (11/4/2011)
GilaMonster (11/4/2011)
There isn't a correlation. If tempDB became huge, some query or queries needed a lot of TempDB space.
Effectively query plans comparison on same query are different.
But I cannot...
--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, 2011 at 8:24 pm

#1403568
RE: order of criteria in where clause changes query palan

Adi Cohn-120898 (11/4/2011)
Inna is a colleague of mine that came across an interesting problem. She had a query that had a wrong query plan. She modified the order...
--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, 2011 at 8:09 pm

#1403567
RE: File system task fails randomly

Stupid question... are you sure that someone isn't resubmitting a job or manually copying the file back?
--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, 2011 at 7:44 pm

#1403565
RE: best method to handle SCD

gugan_ta (11/4/2011)
Hi All,
We are using SCD types in dimension loading. For this we have planned to use default SCD component in SSIS. We also found diffrent methods to handle SCD...
--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, 2011 at 7:43 pm

#1403564
RE: Collation Sequence difference between table variables and temp tables

If all the non-tempdb databases use the same collation but is different than TempDB, wouldn't it be easier to just change the default collation of TempDB?
--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, 2011 at 7:33 pm

#1403562
RE: SQL crash - debug help needed

OLDCHAPPY (11/3/2011)
[font="Courier New"]
Windows Event Logs:
10/30/2011 10:06PM The MSSQLSERVER service terminated unexpectedly.
11/02/2011 11:44AM The MSSQLSERVER service terminated unexpectedly.
In the SQL logs folder, there is an EXCEPTION.log file dated 10/30/2011...
--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, 2011 at 7:19 pm

#1403560
RE: SSIS inserts are very slow

Brandie Tarvin (11/4/2011)
Evil Kraig F (11/3/2011)
I should learn not to post when I'm typing quickly.
Or when you have the lint ball monster from H3CK watching over your shoulder with 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)

November 4, 2011 at 7:14 pm

#1403559
RE: SSIS inserts are very slow

Stefan Krzywicki (11/3/2011)
Each has a GUID primary key.
Unless you defined otherwise, that's likely your problem. Most people define PK's with the default settings and the default settings are 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)

November 4, 2011 at 7:11 pm

#1403557
RE: Why bcp import a file out of order in SQL 2008?

A lot of these problems can be resolved by importing into a staging table using BULK INSERT with OPTION (MAXDOP 1) set. You shouldn't import directly to a final...
--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, 2011 at 6:34 pm

#1403554

Viewing 15 posts - 32,041 through 32,055 (of 59,099 total)