Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,721 through 33,735 (of 59,099 total)

RE: 16 disks Best config design!>

stebennettsjb (6/9/2011)
Hi all,
We have some nice new shiney disks for our sql cluster. Its running 3 instances and we have 16 disks.
My idea was to put:
8 disks RAID...
--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)

June 11, 2011 at 4:41 pm

#1337422
RE: Inserting into an Table with Identity Column from n number of tables

Btw... if the "partitioned view" ended up containing ALL of the rows you want, I wouldn't waste my time doing a "merge". I'd build another table from the view...
--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)

June 11, 2011 at 9:38 am

#1337386
RE: Inserting into an Table with Identity Column from n number of tables

kr.nithin (6/11/2011)
I have another problem.
I need to do this task on different servers. The query fetches the data from my Production Server & I need to update the Table...
--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)

June 11, 2011 at 9:32 am

#1337385
RE: Temp Table Vs Table Variables

WayneS (6/11/2011)
Jeff Moden (6/10/2011)
Please see what I consider to be the definitive article on that subject and others at the following URL: http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
:blush:
Thanks Jeff!
Well it IS! I don't know...
--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)

June 11, 2011 at 9:28 am

#1337383
RE: Using xp_cmdshell to query active directory, global group names are truncated in results

Thanks for the links. I'd found the MS article last night but not the one on the pipeline. I'll take a look.
I also cruise the PowerShell forum here...
--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)

June 11, 2011 at 9:21 am

#1337381
RE: Inserting into an Table with Identity Column from n number of tables

EXCEPT or WHERE NOT IN or WHERE NOT EXISTS.
--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)

June 11, 2011 at 12:11 am

#1337352
RE: How do you avoid dynamic SQL with this code?

CELKO (6/10/2011)
[sic] functins cannto be optimized.
Actually, they can. Lookup "Inline Table Valued Functions" (iTVF) and Cross Apply in Books Online. Then make the realization that iTVF's can...
--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)

June 10, 2011 at 11:33 pm

#1337351
RE: Using SELECT INTO a bad practice?

I'm not sure what all the concerns are about datatyping with SELECT/INTO because it will create the new table with the same datatypes and sizes as the source tables. ...
--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)

June 10, 2011 at 11:17 pm

#1337350
RE: Using SELECT INTO a bad practice?

CELKO (6/10/2011)
>> We have lots of reports which use SELECT INTO to insert data into the temp tables. I was told that it's a bad practice. Could anyone please 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)

June 10, 2011 at 11:03 pm

#1337349
RE: UPPERCASE

Some of the most powerful tools in any computer language are found in the built in functions. UPPER is a pretty easy one to miss. My recommendation would...
--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)

June 10, 2011 at 10:52 pm

#1337348
RE: how to get count of all records on monthly wise.

riys (6/10/2011)
...get count of all records for each month individually [font="Arial Black"]for the latest 6 months[/font].any idea on how to get it??
Yep... Dynamic Cross-Tab. Please see 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)

June 10, 2011 at 10:48 pm

#1337347
RE: Log File Space during Updates of a Table

Grizzly Bear (6/10/2011)
I have a DB on QA Server, which has its Log Space set to 10 GB Restricted Growth. (We like setting our limits to Log Files).
I have...
--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)

June 10, 2011 at 10:35 pm

#1337346
RE: unpivot note

flyingrockfishguy (6/10/2011)
I made a small syntax error in this query, and would have expected an error when I tried to run it. The results are quite interesting.
SELECT ExtraValue,VendorID
Employee,...
--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)

June 10, 2011 at 10:19 pm

#1337345
RE: Temp Table Vs Table Variables

vkundar (6/10/2011)
Hi All,
I have desgined a sproc which is called from a website , this sproc have lots of temp tables which get created calculated etc. I wanted to know:
Hmmm......
--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)

June 10, 2011 at 10:08 pm

#1337344
RE: Using xp_cmdshell to query active directory, global group names are truncated in results

opc.three (6/10/2011)
Maybe I am just being closed-minded here, but I would not choose to kick off any file manipulation tasks directly from T-SQL. I understand the need however so 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)

June 10, 2011 at 8:42 pm

#1337341

Viewing 15 posts - 33,721 through 33,735 (of 59,099 total)