Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,071 through 26,085 (of 59,099 total)

RE: Problems with SQL dumps.....A temporary fix to get you by.

This would make an awesome "Spackle" article especially if you explained how the code works a bit.
--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)

August 28, 2013 at 4:44 pm

#1645780
RE: Get data month to calander week

farrukhhameed786 (8/23/2013)
Hello all,
I need two sample sqlserver queries
1. query get the data 1st date of the month to calendar week like week 1 , week 2 , week 3...
--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)

August 28, 2013 at 3:25 pm

#1645752
RE: How to deny restore database in sql server to SA?

das.saroj09 (8/28/2013)
Hi need a help ?
Mistakenly restored the prod database instance instead of development and i am having full privelage(sysadmin) on the server. can we have any procedure/trigger/server level permission...
--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)

August 28, 2013 at 12:55 pm

#1645714
RE: Delete Vs Truncate difference on rollback

sqlnaive (8/28/2013)
L' Eomot/Gail/Jeff/Scott, One more thing to confirm without wasting much of the time. So it means under a transaction, once the truncate is fired against a table, the data...
--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)

August 28, 2013 at 8:48 am

#1645618
RE: Generate railroad diagrams from Books Online

If your program can do that, then I have to say "Nicely Done".
However, I guess I'm the resident stick in the mud, though. If you compare 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)

August 27, 2013 at 4:34 pm

#1645378
RE: Unexplained Performance Observation

Just keep in mind that if you're storing Sequential GUIDs wherever they're generated from, that it only takes the machine going down once to possibly run into the problem 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)

August 27, 2013 at 2:20 pm

#1645341
RE: check if value is integer

Jason.Reeves (8/27/2013)
Could also use the ISNUMERIC function to check that the data is an integer value.
Be careful, now. Please see the following article for why ISNUMERIC should never be used...
--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)

August 27, 2013 at 12:52 pm

#1645315
RE: will not using the statement terminator ';' break code in future?

GilaMonster (8/27/2013)
davidandrews13 (8/27/2013)
good advice. i'll certainly get in the habit and also update Procedures as-and-when i get to them so that, come day zero, it wont be such a big...
--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)

August 27, 2013 at 12:45 pm

#1645313
RE: NEWID()

I don't have the link for it anymore but I found an MS White Paper on the subject. I believe I found it using "TYPE 4 GUID" as 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)

August 27, 2013 at 10:06 am

#1645264
RE: Do we have possibility to update system tables in SQL..

@mohan.bndr,
I'd still like to know what you're trying to do and why you think updating the system tables is a good idea. Depending on what you're trying to 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)

August 27, 2013 at 10:00 am

#1645263
RE: Delete Vs Truncate difference on rollback

sqlnaive (8/27/2013)
GilaMonster (8/27/2013)
sqlnaive (8/27/2013)
Great... So the correct statement should be:
"DELETE is a logged operation while TRUNCATE is not" as the truncate just deallocates the data pages from the table 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)

August 27, 2013 at 9:57 am

#1645262
RE: Are the posted questions getting worse?

Paul White (8/26/2013)
Jack Corbett (8/26/2013)
I would currently argue that you'd be better off leading with the other key columns in order to see the index get used more...
--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)

August 27, 2013 at 8:59 am

#1645236
RE: Unexplained Performance Observation

BrerSQL (8/26/2013)
Sequential GUIDs definitely would make sense.
I'm not so sure that's true. If the computer is rebooted, the start of a new sequence might not be > the largest...
--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)

August 27, 2013 at 1:23 am

#1645032
RE: SSIS Question Help

Glad some things never change.
I edited my post without realizing that you had responded. Isn't there some "For Each" loop that can get and loop through files in 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)

August 27, 2013 at 1:17 am

#1645030
RE: SSIS Question Help

Koen Verbeeck (8/26/2013)
rocky_498 (8/26/2013)
Thanks, that was I was thinking....
I am thinking how about If I get Recent file name from folder?
Is anyone can please guide me how i can recent...
--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)

August 27, 2013 at 1:12 am

#1645027

Viewing 15 posts - 26,071 through 26,085 (of 59,099 total)