Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,676 through 24,690 (of 59,099 total)

RE: sp_spaceused

Jpotucek (1/23/2014)
SQL Server 2005
I have several databases that have high amounts of unallocated space like this:
MYDatabase (dbsize)8037.00 MB(unallocated space)4665.81 MB
This info was obtained by running sp_spaceused.
What...
--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)

January 23, 2014 at 2:23 pm

#1682940
RE: Capture Backup and Restore operations

AND the SQL Server logs unless you've instantiated the trace flag that turns off reporting of successful backups.
--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)

January 23, 2014 at 2:15 pm

#1682938
RE: Unit Testing for SQL stored procedure

saifmahatab (1/23/2014)
Hi
I am new in SQL server so I need desperate help in doing Unit Testing for bunch of stored procedure that I wrote. So my manager told me 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)

January 23, 2014 at 2:14 pm

#1682936
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Andy DBA (1/23/2014)
Great article! Exellent choice on where to draw the line on its scope.
Also, sometimes it's just as valuable to learn what can't be done as it 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)

January 23, 2014 at 1:36 pm

#1682924
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Thanks folks. Heh... I aim to please... I sometimes miss but I'm always aiming. 🙂
--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)

January 23, 2014 at 9:27 am

#1682849
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

KenpoDBA (1/23/2014)
I love any piece that ends with "crack filled".
Good job on this one. It's to the point and gives good practical advice.
I notice though that with everyone who...
--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)

January 23, 2014 at 7:47 am

#1682789
RE: Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Koen Verbeeck (1/23/2014)
Always funny to see what you categorize as a "short" article Jeff 😀
It's a great one though and I'm sure I'll refer to it soon in the future...
--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)

January 23, 2014 at 6:59 am

#1682759
RE: responsiblities for TempDB

mohan.bndr (1/21/2014)
Can you please describe the responsibilites of TempDB in 2005/2008....
You really should do a Web Search for things like that. Seriously.
--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)

January 22, 2014 at 4:59 pm

#1682624
RE: What do you use to find out what's slowing down your instance right now

GilaMonster (1/21/2014)
sys.dm_exec_requests join sys.dm_exec_sessions cross apply sys.dm_exec_sql_text.
That and a quick trip to the desk of the person who invoked the rogue query along with the appropriate pork chop launcher and...
--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)

January 22, 2014 at 4:56 pm

#1682623
RE: passing a variable to CTE in a view

A view cannot accept parameters. [font="Arial Black"]A view CAN, however, read from a table. Put your parameter in a table [/font]and then read from the view which reads...
--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)

January 22, 2014 at 4:43 pm

#1682622
RE: Mastering Dimensions of Time

PHYData DBA (1/22/2014)
Jeff Moden (1/22/2014)
mtassin (1/22/2014)
Jeff Moden (1/21/2014)
what I've seen on the query plan is that it typically grabs the few rows from the calendar table with a 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)

January 22, 2014 at 2:37 pm

#1682586
RE: Mastering Dimensions of Time

mtassin (1/22/2014)
Jeff Moden (1/21/2014)
what I've seen on the query plan is that it typically grabs the few rows from the calendar table with a clustered index scan (yes a terrible...
--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)

January 22, 2014 at 1:43 pm

#1682572
RE: Any problem with installing SQLServer 2012 on Windows 2012?

Thanks folks. I sure do appreciate the tips and assurances.
--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)

January 22, 2014 at 1:36 pm

#1682570
RE: Mastering Dimensions of Time

@MTassin,
I forgot to ask. Would you be looking up a DayPeriod to get the Date or would you be looking up the Date to get the DayPeriod?
--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)

January 21, 2014 at 11:52 pm

#1682272
RE: Mastering Dimensions of Time

mtassin (1/21/2014)
Jeff Moden (1/21/2014)
Peter,
I know that a non-persisted computed column saves space but it's also recalculated on every use and non-indexable. Since the data won't actually ever change, I'd...
--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)

January 21, 2014 at 9:23 pm

#1682257

Viewing 15 posts - 24,676 through 24,690 (of 59,099 total)