Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,116 through 14,130 (of 59,095 total)

RE: expecting ID or quoted_ID. Help!

p.s. You might want to exclude system databases from the return just to be safe.
--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 11, 2017 at 11:14 pm

#1963310
RE: expecting ID or quoted_ID. Help!

Michael_O - Tuesday, October 10, 2017 9:32 AM
Thom A - Tuesday, October 10, 2017 9:01 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 11, 2017 at 11:02 pm

#1963309
RE: Indexing strategy on a highly transient table

ScottPletcher - Tuesday, October 10, 2017 11:46 AM
giles.clapham - Thursday, October 5, 2017 10:43 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 11, 2017 at 10:28 pm

#1963306
RE: Creating Stored Procedure

dreynolds 13587 - Wednesday, October 11, 2017 9:40 AM
If I understand your requirements correctly, this should do the job: Notice that 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)

October 11, 2017 at 10:12 pm

#1963305
RE: Having trouble displaying a date in a certain format...

chef423 - Wednesday, October 11, 2017 2:24 PM
Phil Parkin - Wednesday, October 11, 2017 1:25 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 11, 2017 at 9:56 pm

#1963303
RE: Having trouble displaying a date in a certain format...

chef423 - Wednesday, October 11, 2017 1:34 PM
FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy hh:mm tt')
Wow, I feel like a numskull, I swear 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)

October 11, 2017 at 9:54 pm

#1963302
RE: Can't zero pad a variable

Phil Parkin - Wednesday, October 11, 2017 2:25 PM
ken.trock - Wednesday, October 11, 2017 2:18 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 11, 2017 at 8:10 pm

#1963297
RE: Order of Indexed columns - does it matter

Also, check the execution count of the INDEX SEEKS in the execution plan. If there's one for every row, that's a very bad thing performance wise.
Last but not...
--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 11, 2017 at 8:03 pm

#1963295
RE: query format

Now to ask the hard question. Do you understand the code well enough to do it again for something else on your own?
--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 11, 2017 at 7:59 pm

#1963294
RE: query format

MinhL7 - Wednesday, October 11, 2017 6:48 PM
They're grouped

CREATE TABLE [dbo].[Title]( [ID] [int] NULL,
[Description] [varchar](50) NULL,
[Dept] [varchar](50) NULL
) 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)

October 11, 2017 at 7:56 pm

#1963293
RE: What Pizzas do DBA's prefer?

My mom used to make a thing called "Upside Down Pineapple Pizza". It wasn't a tomato and cheese based pizza. It was more like a dessert and, man, it made...
--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 11, 2017 at 2:38 pm

#1963275
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Great. My next question is, have you actually tested in your environment to see if compression is actually going to help? On the few large tables I've tested in my...
--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 11, 2017 at 2:35 pm

#1963273
RE: What Pizzas do DBA's prefer?

smallmoney - Wednesday, October 11, 2017 2:02 PM
I prefer Pepperoni Lovers from Pizza Hut
I prefer OPBI... "Other People Bought It".
--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 11, 2017 at 2:16 pm

#1963264
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Why couldn't you just use the same method played against a table of results generated by the first run to control which columns get compressed?
Another search will scare up...
--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 11, 2017 at 2:09 pm

#1963263
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

Tons. See the following link, which will also teach another essential skill in the process.
http://bfy.tw/EQFy
--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 11, 2017 at 1:13 pm

#1963249

Viewing 15 posts - 14,116 through 14,130 (of 59,095 total)