Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,976 through 27,990 (of 59,101 total)

RE: Random index corruption

reguitti (12/5/2012)
Hi all,
I'm having random issues of poor performance with a DB of 40 Gb.
It has more than 1200 tables but when I execute a reindex on a table (named...
--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)

December 5, 2012 at 6:53 am

#1565736
RE: xp_cmdshell works and then doesn't work

Also check other people's jobs and stored procs which may be intentionally turning off xp_CmdShell. People do this thinking they make its use more secure. That's false, 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)

December 5, 2012 at 6:44 am

#1565731
RE: Query to find the start day of the week as Monday

Lynn Pettis (12/4/2012)
Jeff Moden (12/4/2012)
Then substitute a 0 for Michael's -53690. 😀
That, not withstanding, it's always the "edge cases" that cause panic stricken calls at 3 in the morning.
If 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)

December 4, 2012 at 10:26 pm

#1565564
RE: How to improve query with multiple LIKEs with leading wildcards

CELKO (12/4/2012)
Would you try to cut wood with a screw driver?
BWAAA-HAAA!!!! ONLY if I couldn't find my hammer! :-D:-P
--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)

December 4, 2012 at 5:48 pm

#1565545
RE: SQL Server Execution Plans, Second Edition by Grant Fritchey

Lars-640955 (12/4/2012)
No credit belongs to the person who send out this misleading email:
"Free eBook: SQL Server Execution Plans, Second Edition"
And you can quote me on that one!
My time is 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)

December 4, 2012 at 5:47 pm

#1565544
RE: help with date query

Unpivoting is is probably one of the slowest ways to do this. Just write a nice case statement a be done with it.
--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)

December 4, 2012 at 5:43 pm

#1565543
RE: Reduce database size

A lot of people have very large "log" tables that mean nothing in UAT. Find them and truncate them before you do the recommended index and compression things 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)

December 4, 2012 at 5:41 pm

#1565542
RE: Reduce database size

JimS-Indy (12/4/2012)
Sorry, I'm a newbie. What's a 'LUN', and what's a 'UAT'?
LUN is a Logical Unit Number on a SAN (a type of disk system separate from the server).
UAT 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)

December 4, 2012 at 5:38 pm

#1565541
RE: Reduce database size

WolfgangE (12/3/2012)
I would NOT recommend use SHRINKDB "just for fun". Of course is clears all unused disk space but it also can have it's negative impact, from maximum fragmented indexes...
--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)

December 4, 2012 at 5:35 pm

#1565540
RE: Is Table poartition the only way for large Tables

As a side bar, having 20GB of errors would be serious temptation for me to have someone fix the problems in the front end that are causing all of 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)

December 4, 2012 at 5:28 pm

#1565539
RE: Add Many-to-Many all at once

@ Jim,
I'm sure there are other ways to do this but this is about the only place that I actually use GUIDs. I build a sacraficial GUID column 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)

December 4, 2012 at 5:22 pm

#1565537
RE: Add Many-to-Many all at once

Rick Krueger (12/4/2012)
Using the OUTPUT clause is a common pattern for something like this.
Only if you intend to store the parent ID in the child table. Otherwise, it's 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)

December 4, 2012 at 5:17 pm

#1565535
RE: Breaking up a data load to prevent log file growth

capnhector (12/3/2012)
Im coming here to get some options for breaking up a data load. the situation is that i have to expand a set of numbers to cover every...
--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)

December 4, 2012 at 5:15 pm

#1565534
RE: Query to find the start day of the week as Monday

Then substitute a 0 for Michael's -53690. 😀
That, not withstanding, it's always the "edge cases" that cause panic stricken calls at 3 in the morning.
--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)

December 4, 2012 at 5:08 pm

#1565532
RE: Exercises in t-SQL

ScottPletcher (12/4/2012)
It would take far longer than 2 minutes to give the full background you wanted.
This for a simple, introductory interview q, when I often had two more people to...
--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)

December 4, 2012 at 4:54 pm

#1565531

Viewing 15 posts - 27,976 through 27,990 (of 59,101 total)