Jeff Moden

Forum Replies Created

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

RE: OPENROWSET

Budd - Monday, November 26, 2018 9:28 AM
WHT DOES THIS--
select top 1 a.* into #t
from openrowset('SQLNCLI', 'Server=localhost;Trusted_Connection=yes;','SET NOCOUNT ON;SET FMTONLY OFF;...
--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:35 pm

#2014582
RE: OPENROWSET

Phil Parkin - Monday, November 26, 2018 9:39 AM
Why are you using OPENROWSET to do this and not issuing the commands directly?
Heh......
--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:34 pm

#2014581
RE: parse string and check for valid date

Bruin - Monday, November 26, 2018 9:45 AM
How could that be accomplished(example) if no header available.
Thanks.
Read the first row anyway just to...
--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:32 pm

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

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