Jeff Moden

Forum Replies Created

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

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
RE: Extended events question

vsamantha35 - Thursday, July 26, 2018 3:40 AM
Hi All,
I have a question related to extended event ring buffer target.
In SQL Server,...
--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:51 am

#1999099
RE: Are the posted questions getting worse?

Again, no need to pile on but I wanted you to see this one, as well.
https://www.sqlservercentral.com/Forums/1978632/Try-catch-block-in-SQL-statement-not-in-TSQL
Heh... people wonder why I start interviews with 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)

July 26, 2018 at 7:33 am

#1999091
RE: Automate daily table backup

andycadley - Thursday, July 26, 2018 6:48 AM
Indeed. And how you solve the problem if you do care might depend on if...
--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:54 am

#1999078
RE: Cursor Or Not

kd11 - Thursday, July 26, 2018 6:45 AM
That will work for a small sample test data but there are over three thousands...
--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:49 am

#1999074
RE: Automate daily table backup

sgmunson - Thursday, July 26, 2018 6:33 AM
Jonathan AC Roberts - Wednesday, July 25, 2018 5:33 PM
--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:43 am

#1999069
RE: grouping by *

jeffshelix - Wednesday, July 25, 2018 2:00 PM
I have this code:
select
D.*
,H.[Customs_Recon_Entry_Num] as RH_Recon_entry
,max(cast([Recon_File_Date] as Date)) as Recon_File_Date
from
[NAFTAFORD].[STEP1_DUTYIMPACT_MAX3] D
LEft Join
[ADHOC].[ATS_RL] L
on...
--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 5:11 am

#1999052
RE: How to find if a column of a resultset has a content?

BOR15K - Monday, July 23, 2018 2:46 AM
There is a report I print, which includes a list of people, e.g. students, 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)

July 26, 2018 at 5:09 am

#1999050

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