Jeff Moden

Forum Replies Created

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

RE: Are the posted questions getting worse?

Lynn Pettis - Monday, November 26, 2018 2:25 PM
Anyone else just hear the adult noises from a Charlie Brown movie when Mr....
--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 2:31 pm

#2014576
RE: High memory utilization on SQL Server

Sreekanth B - Monday, November 26, 2018 10:36 AM
Jeff Moden - Monday, November 26, 2018 9:48 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 26, 2018 at 1:04 pm

#2014567
RE: Reindexing and Log files

scarr030 - Monday, November 26, 2018 10:42 AM
Maybe I'm misunderstanding your post, but the reindexing job wasn't running, yet the logs...
--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 1:01 pm

#2014566
RE: Reindexing and Log files

scarr030 - Monday, November 26, 2018 8:58 AM
Okay, well the reindexing job was not causing the issue. The job only runs once...
--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 10:02 am

#2014544
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

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