Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,631 through 24,645 (of 59,102 total)

RE: Scanning all tables for highest ID

squeekz01 (1/26/2014)
Hi guys,
I am looking for help with writing what some may find as a basic query... I need to be able to scan all tables in my database for...
--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 26, 2014 at 7:14 pm

#1683409
RE: QA and DB Design team sleeping in same "bed"?

Barkingdog (1/26/2014)
These changes were unexpected and only completed about 2 days before "review meeting 2"...
I guess I understand their outrage, then. I could be wrong but I've always understood...
--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 26, 2014 at 6:27 pm

#1683405
RE: CTE results storage same as temp table?

smallmoney (1/26/2014)
Simple question, are the results of a CTE stored in the same place as a temp table (tempdb)?
Thanks
As with a View or any query, for that matter, they might...
--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 26, 2014 at 6:08 pm

#1683404
RE: Volunteering to gain SQL experience

pietlinden (1/26/2014)
It's a health care company, so they do a lot of data importing, I assume.
The client stated that the candidate must understand Identity in SQL. They need to know...
--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 26, 2014 at 3:15 pm

#1683400
RE: QA and DB Design team sleeping in same "bed"?

Personally, I think having the QA Team in design meetings is one of the most valuable things that can be done in a project provided that a true bi-directional dialog...
--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 26, 2014 at 12:38 pm

#1683386
RE: View vs sp vs functions

zi (1/25/2014)
Dear Experts
I want to know differences between views , stored procedures and functions
And when to choose the appropriate one
Thanks lot
Since it was appropriately brought up, I have to ask...
--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 26, 2014 at 12:16 pm

#1683384
RE: View vs sp vs functions

bitbucket-25253 (1/25/2014)
1). A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is not stored 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)

January 26, 2014 at 12:08 pm

#1683383
RE: View vs sp vs functions

To add to what the others have already stated...
If you write a function as an iTVF or INLINE Table Valued Function, it will work just like a View except for...
--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 26, 2014 at 12:01 pm

#1683382
RE: Value of @@DBTS / timestamp column

vip.blade (1/26/2014)
Hi,
I have a question regarding the timestamp type in SQL Server. As far as I know the timestamp column holds an ever increasing number (every update or insert increments...
--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 26, 2014 at 11:54 am

#1683381
RE: Volunteering to gain SQL experience

pietlinden (1/26/2014)
"Believe it or not, SQL Saturdays are one of the best places to network."
Actually, there were a bunch of recruiter types there last week (#272). Someone actually...
--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 26, 2014 at 11:42 am

#1683380
RE: How to use scalar function without WHILE

vip.blade (1/19/2014)
I have a scalar function, which calculates the similarity of two strings.
Hi.
Would you post that function, please? I could use something like that and I might be able...
--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 26, 2014 at 11:40 am

#1683379
RE: need T-SQL to delete ALL subdirectories within a Directory

Express12 (1/26/2014)
Looking for T-SQL command to delete all subdirectories (and their files) within a master directory --- in a single invocation.
Example, I need to delete ALL subdirectories (and their files)...
--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 26, 2014 at 11:38 am

#1683378
RE: Optimize Update Statement

wit_jp2001 (1/24/2014)
Thanks,
I will try out the new query this afternoon. Just so that eveyone knows this process is to update the 1st SKU with the heaviest SKU. ...
--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 25, 2014 at 6:03 pm

#1683357
RE: Optimize Update Statement

wit_jp2001 (1/24/2014)
Chris - Thanks works great.
If your final code is still using an "=" sign for a NULL test, then it might not actually be doing what it's supposed 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 25, 2014 at 5:40 pm

#1683356
RE: Optimize Update Statement

ChrisM@Work (1/24/2014)
Same statement rewritten as UPDATE FROM, with nonsense logic commented out:
While I agree that the commented out code is incorrectly written, I think it should be rewritten with...
--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 25, 2014 at 5:37 pm

#1683355

Viewing 15 posts - 24,631 through 24,645 (of 59,102 total)