Jeff Moden

Forum Replies Created

Viewing 15 posts - 28,141 through 28,155 (of 59,101 total)

RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

Now wait a minute here.... I thought you had to use the UUID! If you can get away creating your own number, then why are we even worried about...
--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 21, 2012 at 4:22 pm

#1561427
RE: SQL Query: Subtract data from consecutive rows uptil non zero value reached.

This cannot be done reliably because there is nothing in the table to absolutely guarantee the correct order of the data. You must have some column that guarantees 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)

November 21, 2012 at 12:01 pm

#1561365
RE: How do I get database space used

sql-lover (11/21/2012)
@anthony-2,
Thanks for sharing that piece of code. I'll take a look
Now, not trying to be a "pain in the butt" but how a cursor can be bad on my...
--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 21, 2012 at 11:53 am

#1561358
RE: interview questions

Eugene Elutin (11/21/2012)
Alvin Ramard (4/17/2009)
Nicholas Cain (4/17/2009)
Here's my personal favourite to spring:
It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million...
--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 21, 2012 at 7:26 am

#1561252
RE: New DBA job, done some digging on Database and have some concerns!

stephen.sarre (11/21/2012)
Hi
Before any fixes that you think are "essential", make sure your manager agrees the priorities, in particular new work vs schema fixes, backups, reindexing or DBCCs etc
Only do essential...
--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 21, 2012 at 7:07 am

#1561239
RE: DTEXEC Failing with Xp_cmshell but runs in cmd line

Chad Vollmer (11/20/2012)
Thanks for the response, it actually was a security issue we were actually testing a new service account on that box which did not have rights. We switched...
--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 21, 2012 at 7:02 am

#1561235
RE: rebuild index worsens query performance

jgenovese (11/20/2012)
All:
This was literally a "switch-flip" -- the query run time doubled exactly right after I made the changes noted in my original post
(note: on that day I rebuilt...
--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 21, 2012 at 6:52 am

#1561230
RE: Time out in insert statement

mah_j (11/21/2012)
Thank you both for your comments.
Does it have any effect,If i implement partitioning only on one drive ?
I will read more,and also focus on partitioning.
Paritiioning really isn't a performance...
--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 21, 2012 at 6:01 am

#1561219
RE: interview questions

naga.rohitkumar (11/21/2012)
awesome reply alivn
from my point of view ithnk so if not please correct ----any one can suggest me------
coz inthis sort of scenarios only u will have two options
1....
--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 21, 2012 at 5:38 am

#1561212
RE: Load newly inserted data from millions of records on daily basis-Using SSIS

Instead of growing your own form of replication, why not just setup replication for that 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)

November 20, 2012 at 10:10 am

#1560911
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

Bhuvnesh (11/20/2012)
Jeff Moden (11/18/2012)
make sure that you have a good FILL FACTOR on the index for the GUID.
Please explain 🙂
Sure... it's a huge subject with lots of caveats that...
--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 20, 2012 at 9:20 am

#1560880
RE: How to remove trailing zeros and decimal?

jchicky (11/20/2012)
Thanks for your reply. They want it this way to save space. Right now, it rounds off to 2 decimal places--so why have "Opportunity (2.00M)" when you can 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)

November 20, 2012 at 8:43 am

#1560852
RE: how to remove characters char(0) to char(31)

Mark-101232 (11/19/2012)
Jeff Moden (11/19/2012)
@mark-3,
That was also pretty quick. Have you been using such a thing? If so, what's your take on performance here (And, yes, I still 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)

November 19, 2012 at 8:06 am

#1560383
RE: Char And int

Eskandari (10/10/2012)
Consider this Table :
CREATE TABLE Test ( field_one nvarchar(10) );
DECLARE @i int;
WHILE @i<= 1000
BEGIN
...
--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 19, 2012 at 7:16 am

#1560360
RE: Char And int

ChrisM@home (10/15/2012)
Jan Van der Eecken (10/15/2012)
Nice one, Tom! But does the TRY_CONVERT() make the query non-sargeable? Guess it would?
Good point, Jan. I remember recently Howard W posted evidence that CAST(Datetime...
--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 19, 2012 at 7:11 am

#1560354

Viewing 15 posts - 28,141 through 28,155 (of 59,101 total)