Jeff Moden

Forum Replies Created

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

RE: HElp with a query!!

The following article should help...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--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 5:16 pm

#1645786
RE: Using OSQL in VS Command Prompt (2010)

What kind of problems are you having? Any error messages?
--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 5:12 pm

#1645784
RE: Problem with data conversion

Luis Cazares (8/28/2013)
I'm trying to import a flat file into a table in my SQL Server database. However, the derived column transformation is giving an error but only on certain...
--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 5:04 pm

#1645783
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

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