Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,101 through 23,115 (of 59,102 total)

RE: How to find number of columns returned from query in powershell

Chand00 (7/25/2014)
I want to find out number of columns returned from a query in a powershell script.
As we will be passing a dynamic query which can retrieve only 2 columns...
--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 25, 2014 at 11:16 am

#1732470
RE: Cross Join Help

dwilliscp (7/25/2014)
I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource"...
--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 25, 2014 at 11:12 am

#1732469
RE: Get next 2 weeks

sharonsql2013 (7/25/2014)
True, I cannot change the table .
Name is the name of the person , Project is the projectname and all the weeks represent the hours worked 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 25, 2014 at 11:01 am

#1732465
RE: Exploring Recursive CTEs by Example

David McKinney (7/17/2012)
I love it! Especially the conclusion.
It's time we stopped being afraid to whisper the words 'Recursive CTE' for fear of being heard by the RBAR...
--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 25, 2014 at 9:41 am

#1732433
RE: Latin1_General_BIN Collation

Eric Humphrey (7/24/2014)
Choose Windows collation.
Designer: Latin1_General
Check Binary. All other options become invalid at that point.
I realize that you and I have just answered a 2 year post but I thought...
--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 24, 2014 at 7:19 pm

#1732235
RE: How to keep Canadian and US customers database separate in their country

If you have database servers in each country, I believe that you're missing a prime opportunity for disaster recovery. All customers should be in the same database and 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 24, 2014 at 7:12 pm

#1732234
RE: Help with creating a SQL script.

New Born DBA (5/29/2014)
Ed Wagner (5/29/2014)
Good. Create a stored procedure and schedule it to run as a database job every hour. The procedure would query the number of...
--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 24, 2014 at 6:59 pm

#1732233
RE: Need Help parsing through the XML

Evil Kraig F (7/22/2014)
Jeff Moden (7/22/2014)
What's so bad about using something like BCP to export the data to a central transfer repository and simply import the data at the other...
--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 24, 2014 at 6:41 pm

#1732231
RE: T-SQL Pivot Question

Alan.B (7/24/2014)
Hi Jeff, sorry for the later reply here - I have been off the grid dealing with health issues.
I fixed my code - please let me know if...
--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 24, 2014 at 6:24 pm

#1732228
RE: I am Confused about SQL Server performance

Coderx7 (7/24/2014)
Hello Everyone,
About two months ago me and two of my friends tried to see for ourselves whether Oracle is faster than SQL Server or vice versa, and or if...
--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 24, 2014 at 6:20 pm

#1732226
RE: Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ?

kbhanu15 (7/14/2014)
Hi ALl,
Please give your suggestions to resolve this problem.
Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ?
I've run into this 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)

July 24, 2014 at 6:08 pm

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

Alvin Ramard (7/24/2014)
Jeff Moden (7/23/2014)
halifaxdal (7/23/2014)
Alvin Ramard (7/23/2014)
Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import 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)

July 24, 2014 at 11:08 am

#1732158
RE: Backing up a DB with log shipping turned on

Perry Whittle (7/23/2014)
Jeff Moden (7/21/2014)
Perry Whittle (7/21/2014)
Steve Jones - SSC Editor (7/21/2014)
GilaMonster (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
Yes. I believe you can use copy only, which avoids this
Full backups 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)

July 24, 2014 at 10:44 am

#1732152
RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

opc.three (7/24/2014)
To anyone reading this article and subsequent comments, know that BULK INSERT introduces problems and carried with it many more hidden limitations than it offers benefits. BCP (the command-line...
--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 24, 2014 at 9:15 am

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

halifaxdal (7/24/2014)
Jeff Moden (7/23/2014)
halifaxdal (7/22/2014)
For the 400M file, I remove the first two rows (non data), I also added BULKSIZE = 200 to the Bulk Insert, and I was able...
--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 24, 2014 at 8:42 am

#1732115

Viewing 15 posts - 23,101 through 23,115 (of 59,102 total)