Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,546 through 19,560 (of 59,098 total)

RE: Temp Table's Primary Key Default

rchantler (9/25/2015)
Is a primary key on a temp table implemented as a clustered index by default, or as a unique index by default?
Both. As on a normal table, 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)

September 25, 2015 at 4:56 pm

#1829663
RE: Convert Cursor to a Recursive CTE or a normal Query

Luis' code is wonderful but it's missing a very important part. Although the use of QUOTENAME certainly helps, you really should delouse the inputs for @CompanyName and @TableName prior...
--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)

September 25, 2015 at 9:14 am

#1829524
RE: xp_cmdshell security risk: Any other option

nikhil.desai1 (9/19/2014)
Hi,
As per SQL sever hardening xp_cmdshell is a security risk.
Actually, it's not a security risk if you do it correctly.
First, you should never give an individual proxy privs...
--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)

September 25, 2015 at 9:01 am

#1829513
RE: Executing query/SPs thru Command line

Tac11 (9/24/2015)
Wow. Just asked simple questions, no answer but too much noise!!!!
No problem. Moving on. 😉
--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)

September 24, 2015 at 7:02 pm

#1829348
RE: Disabling Indexes for Load Performance

Chris-475469 (9/23/2015)
Thanks for pointing that out, Jeff.
The process is using SSIS but I believe it has been set up quickly just to get it working, not necessarily with performance in...
--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)

September 23, 2015 at 7:46 pm

#1829003
RE: Choosing values

Manic Star (9/23/2015)
patricklambin (9/23/2015)
Stewart "Arturius" Campbell (9/22/2015)
Interesting question, thanks Steve
Another of the functions copied from Excel.
I don't think so. These functions have been introduced only to make easier the translation...
--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)

September 23, 2015 at 7:42 pm

#1829001
RE: Delete Columns from TSV

@Phil,
So does that mean that you have to manually click on 480 columns in step 6?
--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)

September 23, 2015 at 7:29 pm

#1828998
RE: rebuild index worsens query performance

nancy.gs.chuah (9/23/2015)
Just wondering, have you got to the bottom of this?
I am experiencing the same issue in our PROD environment as well. The performance was relatively fast...
--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)

September 23, 2015 at 6:33 pm

#1828992
RE: Why is CDC returning Insert/Delete when I UPDATE a row in a table?

Christophe.Bejjani (9/23/2015)
That might help
https://support.microsoft.com/en-us/kb/238254
https://support.microsoft.com/en-us/kb/302341
Great links. Thanks and welcome aboard.
--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)

September 23, 2015 at 6:20 pm

#1828990
RE: Inserting rows a row at a time instead of in batches- RBAR is faster???

Maxer (9/23/2015)
I was speaking with a work colleague and the topic of inserts came up.
I had suggested doing the inserts in batches. We were taking data from an OLTP...
--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)

September 23, 2015 at 6:18 pm

#1828989
RE: I think this is a Check Constraint question.

jameslauf (9/23/2015)
I am sorry I re-Read my original post and i was unclear.
I want individual LineitemNumbers per each InvoiceId.
so I cna have Invoice#97865 with LineItemNumbers 1,2,3.
right now I...
--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)

September 23, 2015 at 5:57 pm

#1828986
RE: Executing query/SPs thru Command line

Tac11 (9/23/2015)
Hi experts,
How do I execute below scripts using CMD:
Please Note: SQL server 2008r2, default instance with window Authentication.
1. Select * from Adventurewoks2008.Person.Person where Id = 5
2. Exec usp_getemployee...
--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)

September 23, 2015 at 5:53 pm

#1828985
RE: MS-Jet Engine 4.x ODBC enabled databases to 1 Terabyte/5 billion rows (or) SQL SERVER?

Just to ask the question again...
Jeff Moden (9/22/2015)
@erichansen1836
Just a quick question and apologies for not following/reading all of the posts that have occurred since the last time I dropped...
--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)

September 23, 2015 at 5:44 pm

#1828982
RE: Disabling Indexes for Load Performance

Don't drop or disable the clustered index.
As someone already said, if you disable the clustered index, none of the data will be available.
If you drop the clustered index,...
--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)

September 23, 2015 at 5:39 pm

#1828981
RE: Import CSV. Multiple Rows. Split order when items total 720g

chris-1111548 (9/23/2015)
SSIS 2008
Hi there,
we import orders for our clients from .csv text files that they provide us each day.
For us to achieve the maximum discount from Royal Mail our items...
--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)

September 23, 2015 at 4:54 pm

#1828978

Viewing 15 posts - 19,546 through 19,560 (of 59,098 total)