Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,701 through 11,715 (of 59,102 total)

RE: Changing table name used in function, stored procedure and views

If the VIEWS are created correctly, they they'll use the underlying indexes, etc, of the tables just fine.
I do agree with the others that the use...
--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)

July 30, 2018 at 7:32 am

#1999464
RE: Get 2 decimals in my query

GG_BI_GG - Tuesday, July 24, 2018 12:50 AM
SELECT 'Per Category' AS Category,
[1], [2], [3], [4], [5], [6], [7], [8]
FROM ...
--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)

July 28, 2018 at 5:46 am

#1999348
RE: Get 2 decimals in my query

andycadley - Wednesday, July 25, 2018 12:34 PM
DDL will definitely help people to help you. You might want to investigate the FORMAT...
--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)

July 28, 2018 at 5:42 am

#1999347
RE: Automate daily table backup

Ah... yeah. Agreed.
Unfortunately, it looks like the OP has flown the coop.
--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)

July 27, 2018 at 7:39 pm

#1999333
RE: SQL/DBA freelance work

Let's see... you've posted no references, no links, no resume, you joined this site 9 years ago, made exactly one reply post, and now you expect this site to 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)

July 27, 2018 at 9:28 am

#1999260
RE: Speeding Up Incremental ETL Proceses in SSIS by Using MD5 Hashes

sabyasm - Thursday, September 2, 2010 10:22 AM
[font="Comic Sans MS"]This is an excellent article.However - I am facing a peculier problem that...
--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)

July 27, 2018 at 7:50 am

#1999241
RE: How to pass and use Variable on CTE

luissantos - Friday, July 27, 2018 7:14 AM
Hello,
Thanks for all your replies , i will go create function to split values.
Many thanks
LS
I'll...
--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)

July 27, 2018 at 7:46 am

#1999240
RE: dm_db_index_physical_stats - LIMITED or DETAILED

p.s. Am I suggesting that you should use GUIDs in all cases? NOT ON YOUR LIFE! If you truly have an APPEND ONLY INSERT index that suffers no "ExpAnsive"...
--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)

July 27, 2018 at 7:41 am

#1999236
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Leo.Miller - Thursday, July 26, 2018 8:40 PM
I'm really interested in this:
And let me know if those 3rd party apps are...
--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)

July 26, 2018 at 10:46 pm

#1999193
RE: dm_db_index_physical_stats - LIMITED or DETAILED

Leo.Miller - Wednesday, July 25, 2018 8:46 PM
Being in the SQL Server Managed Services business I (we) have too many clients...
--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)

July 26, 2018 at 6:50 pm

#1999186
RE: Joining large tables to small tables.

andycadley - Thursday, July 26, 2018 12:18 PM
sgmunson - Thursday, July 26, 2018 11:26 AM
--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)

July 26, 2018 at 3:21 pm

#1999171
RE: Deleting Data

Eric M Russell - Thursday, July 26, 2018 7:02 AM
That guy in the dapper suit with no history and the perfectly crafted...
--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)

July 26, 2018 at 10:32 am

#1999129
RE: Are the posted questions getting worse?

Sean Lange - Thursday, July 26, 2018 8:17 AM
Some of you probably know that I have played bass in several bands over...
--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)

July 26, 2018 at 8:30 am

#1999112
RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, July 26, 2018 7:43 AM
Jeff Moden - Thursday, July 26, 2018 7:33 AM
--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)

July 26, 2018 at 8:12 am

#1999108
RE: Are the posted questions getting worse?

Luis Cazares - Thursday, July 26, 2018 7:45 AM
Jeff Moden - Thursday, July 26, 2018 7:33 AM
--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)

July 26, 2018 at 7:59 am

#1999102

Viewing 15 posts - 11,701 through 11,715 (of 59,102 total)