Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,516 through 10,530 (of 59,095 total)

RE: High memory utilization on SQL Server

You're paying through the nose for the Enterprise Edition, you have 750 databases, and you're trying to do it all on 1/2 of 98GB? My recommendation would be to first...
--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)

November 26, 2018 at 9:48 am

#2014543
RE: The funny WHERE

Great question. Although preferable, this is one of the reasons why you "must look eye" when variables and columns are named the same.
--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)

November 25, 2018 at 7:57 am

#2014443
RE: Passing a parameter inside a statement

sinds1962 - Sunday, November 25, 2018 2:28 AM
Jeff Moden - Saturday, November 24, 2018 11:24 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)

November 25, 2018 at 7:47 am

#2014442
RE: Index Rebuild Online - Actual Execution Plan.

The answer is pretty simple (IMHO). If you look at the "Messages" tab, you'll notice there was absolutely no report of the number of row affected. That's because 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)

November 24, 2018 at 1:51 pm

#2014431
RE: Inserting a new row into a table using a cursor

josetur12 - Saturday, November 24, 2018 12:33 PM
Hi, the data involved in this task is fairly small. So, I think the cursor...
--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)

November 24, 2018 at 1:50 pm

#2014430
RE: Passing a parameter inside a statement

sinds1962 - Saturday, November 24, 2018 3:59 AM
The data type of dateID is varchar (8)
{shiver}
VARCHAR carries an extra 2 bytes of...
--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)

November 24, 2018 at 11:24 am

#2014427
RE: Tempdb and prop fill

muthukkumaran Kaliyamoorthy - Friday, November 23, 2018 1:24 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)

November 24, 2018 at 11:04 am

#2014426
RE: Exif data into a database.

ben.brugman - Friday, November 23, 2018 7:01 AM
Jeff Moden - Thursday, November 22, 2018 1:04 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)

November 24, 2018 at 10:47 am

#2014425
RE: parse string and check for valid date

Bruin - Friday, November 23, 2018 6:05 AM
I was looking for a generic Insert that would read a csv and dynamically create...
--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)

November 24, 2018 at 10:41 am

#2014424
RE: Inner joins

drew.allen - Friday, November 23, 2018 8:16 AM
Jeff Moden - Wednesday, November 21, 2018 1:03 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)

November 23, 2018 at 12:08 pm

#2014409
RE: Tempdb and prop fill

sqlguy7777 - Thursday, November 22, 2018 6:32 PM
Hi
We have a SQL 2012 server with Tempdb that has 4 data files.
The Tempdb...
--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)

November 22, 2018 at 6:55 pm

#2014370
RE: Getting the main course right

Ah... beware... I just had a trusted friend tell me that he's been testing TRANSLATE and that, unless you use something like binary collation, it's a dog for performance. 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)

November 22, 2018 at 5:33 pm

#2014367
RE: Looking for a great candidate in Virginia Beach - ASAP

I'm curious. What if you can't find someone that's both a good solid Mid-Level DBA and has a Secret Clearance? What if you can only find a good solid Mid-Level...
--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)

November 22, 2018 at 2:37 pm

#2014359
RE: slow query

atulyan.aries - Wednesday, November 7, 2018 2:11 PM
the query has a Where clause that 2 conditions combined via AND. If only 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)

November 22, 2018 at 2:19 pm

#2014358
RE: Slow run time

Admingod - Wednesday, November 7, 2018 10:25 AM
Thanks! However, i don't need help on the execution plan, all i am looking 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)

November 22, 2018 at 2:13 pm

#2014357

Viewing 15 posts - 10,516 through 10,530 (of 59,095 total)