Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,516 through 19,530 (of 59,072 total)

RE: President Xi's and President Obama's agreement to curb economic cyberspying.

andrewbb (9/27/2015)
Jeff Moden (9/27/2015)
There are two problems with you're good solutions, IMHO...
1. They're usage is not enforceable.
2. They only address a small part of the problem.
It is a...
--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 27, 2015 at 5:52 pm

#1829774
RE: President Xi's and President Obama's agreement to curb economic cyberspying.

There are two problems with you're good solutions, IMHO...
1. They're usage is not enforceable.
2. They only address a small part of the problem.
--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 27, 2015 at 11:00 am

#1829761
RE: No Time for Testing

From the article:
What I don't get is why we don't just mock up a quick test that we can run in an automated fashion.
First, I loved your observations 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)

September 27, 2015 at 10:48 am

#1829759
RE: Pagination in T-SQL to be done on 50000 records . Display 20 rows at single time

myzus2004 (9/25/2015)
The execution plan is Index seek or clustered index scan almost everywhere
Note that "clustered index scan" is a fancy name for "table scan".
--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 5:03 pm

#1829664
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

Viewing 15 posts - 19,516 through 19,530 (of 59,072 total)