Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,886 through 21,900 (of 59,072 total)

RE: Differential backup pushing a full backup?

Tony++ (1/13/2015)
To ask the silly and obvious: Are they both either compressed or uncompressed?
Doing full as compressed & diffs as uncompressed could get you that closeness in size.
I think part...
--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 13, 2015 at 8:02 am

#1769825
RE: Best way to migrate data from 2005 to 2008R2 env

SQLisAwE5OmE (1/12/2015)
Grant Fritchey (1/12/2015)
If it's a one-time data move, the easiest is going to be to just do a restore. You can drop all the objects on the other side...
--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 13, 2015 at 1:43 am

#1769724
RE: Inserting FK information into a temp table

Roust_m (1/8/2015)
JeeTee (1/8/2015)
if this is to perform cross database maintenance, powershell might be a better option (one which I'm altogether not familiar with). But what I was saying about 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)

January 13, 2015 at 1:40 am

#1769721
RE: Tables design similar to google calendar scheduling

You bet, Vishnu. Thank you for the feedback.
--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 13, 2015 at 1:34 am

#1769718
RE: Is there a better way to write this query.

curious_sqldba (1/12/2015)
I am trying to load data in batches on 10 K. The select statement at the bottom is taking about 60 % of the cost, is there better way...
--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 12, 2015 at 9:24 pm

#1769696
RE: Tables design similar to google calendar scheduling

vishnu.vardhan414 (1/12/2015)
Hi All,
I have a problem in Designing tables for events which are scheduling daily,weekly, monthly and yearly.
My current design for Scheduling 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 12, 2015 at 9:10 pm

#1769691
RE: Differential backup pushing a full backup?

Benki Chendu (1/12/2015)
Grant Fritchey (1/12/2015)
Then the implication is that you have some process or other that's hitting 400 of the 500gb worth of pages on your database. Is there 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)

January 12, 2015 at 8:44 pm

#1769690
RE: Merry Christmas 2014

TomThomson (12/29/2014)
Iwas Bornready (12/29/2014)
I would never do it this way.
I would.
It's much more fun than messing about with strings as Hugo suggests, because it provides useful mental excercise;...
--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 12, 2015 at 5:01 pm

#1769680
RE: Altering datatype from varchar to nvarchar

The most serious impact is that you will double the size of all the data in the affected columns (including anywhere they're used in an index) because NVARCHAR takes 2...
--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 12, 2015 at 4:46 pm

#1769678
RE: Are the posted questions getting worse?

Ed Wagner (1/12/2015)
Koen Verbeeck (1/12/2015)
Jo Pattyn (1/12/2015)
Glad you keep the thread awake
Now that you are here: the mustard is excellent 😉
Especially the stone-ground mustard. It has much more character...
--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 12, 2015 at 3:56 pm

#1769668
RE: How to add missing IDs in a SQL table?

srinivas.akyana (1/12/2015)
I am not worried about other attributes in the same table. Could you please help me with some pointers on the same.
From the looks of it, you should be...
--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 12, 2015 at 3:54 pm

#1769667
RE: char(n) v varchar(n) - data type length question

As Lowell stated, LEN() will only return the number of characters in a string (with a caveat that I'll explain in a minute) whereas DATALENGTH will return the number 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)

January 12, 2015 at 3:52 pm

#1769666
RE: Error messages

Aaron N. Cutshall (1/12/2015)[hrThat's why I have a huge problem with certification exams. They don't require one to UNDERSTAND the problem but merely to be able to repeat 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 12, 2015 at 12:03 pm

#1769602
RE: Error messages

Ed Wagner (1/12/2015)
Jeff Moden (1/11/2015)
Reminds me of a question I once saw on a non-MS exam...
Which of the following Recovery Models will allow for minimally logged index rebuilds?
A. Bulk Logged
B....
--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 12, 2015 at 11:59 am

#1769600
RE: Tempdb Shrink takes long time.

Siva Ramasamy (1/12/2015)
Dear experts,
Thanks for showing interest in my question and sharing your knowledge to help me out.
The total drive size is about 2.5 TB out of which 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)

January 12, 2015 at 8:38 am

#1769531

Viewing 15 posts - 21,886 through 21,900 (of 59,072 total)