Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,301 through 27,315 (of 59,101 total)

RE: Query Performance & Optimization tips

jamessdba (3/5/2013)
Hi,
Please post Query Performance & Optimization tips for production sql server 2005 Database
I mean both Developer & DBA view.
Thanks in advance
This is a huge subject. I recommend you...
--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)

March 5, 2013 at 7:11 am

#1593465
RE: Working with SQL Server Recovery Models

Good overview for beginners. There are a couple of points that I think should have been included or are actually incorrect.
First, in the Simple Recovery mode section, you say...
This...
--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)

March 5, 2013 at 6:54 am

#1593454
RE: Database Backup Issue

shijobaby (3/4/2013)
http://answerforu.com/2011/09/26/server-msg-3201-level-16-state-1-line-1-cannot-open-backup-device-epubs-dat-device-error-or-device-off-line-see-the-sql-server-error-log-for-more-details-server-msg-3013-level-16-stat/%5B/url%5D
You are a hairball. All you've done is make an illegal copy of Microsoft Documentation at the following URL.
http://support.microsoft.com/kb/207187
I wonder how your sponsors will feel about finding out...
--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)

March 4, 2013 at 9:30 pm

#1593271
RE: query performance

There are a couple of suggestions.
1. Make sure the queries are actually SARGable where an INDEX SEEK followed by an internal scan can be accomplished.
2. Possibly, normalize 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)

March 4, 2013 at 8:20 pm

#1593265
RE: 6 places after decimal without rounding

Considering that you're only working with 6 digits to begin with, consider transposing your formula for a smidgen more accuracy.
UPDATE dbo.Analysis
SET AccMargin = ((MArgin+Freight)/Gallons)
Of course, since you're doing decimal...
--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)

March 4, 2013 at 8:12 pm

#1593264
RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

Actually, and just like many other threads with interview questions on them, a lot of the interview questions range from flat out wrong to excellent. The cool part is...
--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)

March 4, 2013 at 7:57 pm

#1593261
RE: UDF Help

So, just like I said in the article, Scalar functions aren't always as bad as they've been made out to be but a true iTVF will easily beat the tar...
--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)

March 4, 2013 at 7:51 pm

#1593259
RE: Guidance on table valued types.

Arjun Sivadasan (3/3/2013)
Jeff Moden (3/3/2013)<snip/> For example, 40,000 INDEX SEEKs behind the scenes can be quite a bit slower than a single scan at the leaf level.
Jeff, in this case,...
--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)

March 4, 2013 at 7:40 pm

#1593256
RE: How to maintain two digit values in sp?

True enough but in this lawsuit happy 21st century, it's gonna happen. We had a guy here in Michigan that got sued and lost. He was out 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)

March 4, 2013 at 7:36 pm

#1593255
RE: MaxDOP Query Hint

Then I believe you're pretty much stuck with dynamic SQL in one form or another.
--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)

March 4, 2013 at 7:24 pm

#1593252
RE: Select full month number (with 0)

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).
I was just curious as to 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)

March 4, 2013 at 7:22 pm

#1593251
RE: Copy a big table (250G) form one server to another

In that case, you might try what SQL Server itself uses for replication if you have the disk space. BCP in native format. Export the table to 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)

March 4, 2013 at 7:17 pm

#1593250
RE: Select full month number (with 0)

ScottPletcher (3/4/2013)
Jeff Moden (3/4/2013)
@scott,
I'm not so sure why you insist on using codes for literal dates, but I prefer not to.
Where in the world did I suggest using a format...
--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)

March 4, 2013 at 5:20 pm

#1593232
RE: Select full month number (with 0)

@scott,
I'm not so sure why you insist on using codes for literal dates, but I prefer not to.
Where in the world did I suggest using a format code for anything?...
--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)

March 4, 2013 at 4:56 pm

#1593224
RE: How to split query result into seperate columns

Sean Lange (3/4/2013)
Ed Wagner (3/4/2013)
Thanks, Sean. Good article. You know, I'm consistently impressed by just how many different uses there are for the tally table. So simple...
--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)

March 4, 2013 at 4:49 pm

#1593222

Viewing 15 posts - 27,301 through 27,315 (of 59,101 total)