Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,996 through 11,010 (of 59,099 total)

RE: What are some really dumb things you could write in a SQL Query

ScottPletcher - Wednesday, October 10, 2018 4:16 PM
Jeff Moden - Wednesday, October 10, 2018 3:49 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)

October 10, 2018 at 5:07 pm

#2008972
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 2:42 PM
Correct. Reorg (and anything else) can't move rows to the right in the index...
--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)

October 10, 2018 at 4:36 pm

#2008970
RE: Are Indexes Actually Changes to the System?

Paul Randal - Wednesday, October 10, 2018 10:30 AM
Jeff - can you explain this comment you made please: "NEVER USE REORGANIZE!!!!...
--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)

October 10, 2018 at 4:34 pm

#2008969
RE: What are some really dumb things you could write in a SQL Query

ZZartin - Wednesday, October 10, 2018 2:17 PM
SELECT * in a deployed production job
A very strong code smell, indeed, but as 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)

October 10, 2018 at 3:54 pm

#2008965
RE: What are some really dumb things you could write in a SQL Query

ScottPletcher - Wednesday, October 10, 2018 10:47 AM
In terms of potential lost performance and wasted resources, this is probably the single...
--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)

October 10, 2018 at 3:49 pm

#2008964
RE: Need help in converting Nvarchar to Datetime

Jonathan AC Roberts - Wednesday, October 10, 2018 8:55 AM
Bujji1987 - Wednesday, October 10, 2018 7:35 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)

October 10, 2018 at 9:14 am

#2008864
RE: Difference between two join method

crmitchell - Wednesday, October 10, 2018 8:06 AM
I tend to prefer keeping join criteria separate from filtering criteria so would generally go...
--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)

October 10, 2018 at 8:32 am

#2008847
RE: Need help in converting Nvarchar to Datetime

Keith Oliver - Wednesday, October 10, 2018 7:58 AM
DECLARE @ndate nvarchar(50) = N'2010/03/15 01'
SET @Ndate = @ndate + ':00:00'
SELECT CONVERT(datetime, @ndate, 101)
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)

October 10, 2018 at 8:30 am

#2008844
RE: Need help in converting Nvarchar to Datetime

SELECT CONVERT(DATETIME,REPLACE('03\15\2010 01'
--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)

October 10, 2018 at 7:52 am

#2008825
RE: Showing all records that appear more than once

j.clay 47557 - Wednesday, October 10, 2018 2:48 AM
OK, thanks John.
I think that's above my SQL knowledge unfortunately. I'll do it 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)

October 10, 2018 at 7:46 am

#2008821
RE: How else can I view last queries run by anyone on an instance of SQL Server or a particular DB

Jeff Moden - Thursday, October 4, 2018 9:13 PM
VoldemarG - Tuesday, October 2, 2018 7:35 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)

October 10, 2018 at 7:44 am

#2008819
RE: Database Management vs Database Administration Meaning

Grant Fritchey - Wednesday, October 10, 2018 5:16 AM
Try the veal.
😀
--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)

October 10, 2018 at 7:27 am

#2008812
RE: Are the posted questions getting worse?

jasona.work - Wednesday, October 10, 2018 6:51 AM
Ever have one of those days at work, where you feel like, despite everything going...
--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)

October 10, 2018 at 7:26 am

#2008811
RE: Information from ALL SQL Servers

Let's consider what can actually happen with some software that's actually capable of monitoring "enterprise wide" or even just "domain wide" if someone learns the password(s) for the user login(s)...
--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)

October 10, 2018 at 6:47 am

#2008802
RE: What are some really dumb things you could write in a SQL Query

andrew gothard - Wednesday, October 10, 2018 3:08 AM
Jeff Moden - Tuesday, October 9, 2018 10:09 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)

October 10, 2018 at 6:29 am

#2008796

Viewing 15 posts - 10,996 through 11,010 (of 59,099 total)