Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,121 through 24,135 (of 59,102 total)

RE: TEMPDB on RAM

jeffrey yao (3/19/2014)
MS actually does have "TempDB in RAM" today. It defaults to that and only spills to disk if it gets too large for a given session. ...
--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)

March 19, 2014 at 1:39 pm

#1698508
RE: Is it possible to use a parameter for csv values

Ed Wagner (3/19/2014)
Another approach is to convert the list into a table and then run your query against the table. Here's an example using @strParams as your passed parameter...
--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)

March 19, 2014 at 9:11 am

#1698415
RE: TEMPDB on RAM

jeffrey yao (3/17/2014)
I actually initially did not want to continue in this thread because I do not see there are any fundamental differences between everyone's views (ie. making tempdb quicker...
--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)

March 18, 2014 at 2:46 pm

#1698196
RE: Newbie With Issue

elee1969 (3/18/2014)
I was able to resolve issue.
Thanks.
What did you do to resolve 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)

March 18, 2014 at 2:25 pm

#1698191
RE: Bitwise OR function

joakim.fenno (3/18/2014)
The bit_flag column contains 12 flag (and is therefore a nvarchar(12)) in the real example
Gosh. That's 24+2 or 26 bytes to store what could be stored in less...
--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)

March 18, 2014 at 2:13 pm

#1698188
RE: How are you adding a semi-colon to existing SQL code when upgrading?

A combination of 1 and 4 for me. As we do necessary rework or upgrades of code, we add the semi-colons. If we miss some, we'll pick them...
--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)

March 18, 2014 at 2:07 pm

#1698184
RE: Why would wrapping a TSQL query in an if statement increase its runtime significantly?

hunchback (3/17/2014)
Try using NOT EXISTS instead NOT IN.
if exists(
select *
from Responses r
where not exists (
...
--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)

March 18, 2014 at 2:04 pm

#1698182
RE: t-sql datetime conversion issue

wendy elizabeth (3/17/2014)
got the sql to work
So, what did you do to get it to work? Two way street here. 😉
--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)

March 18, 2014 at 11:19 am

#1698136
RE: How do I get stats on this special "binary" field?

halifaxdal (3/17/2014)
Too bad! Only beautifully working on my local 2k8, when I run it on server 2k5, it fails with the term "VALUES"
CROSS APPLY( VALUES(1, SUBSTRING(d.Category, 1, 1)),
is VALUES...
--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)

March 17, 2014 at 12:54 pm

#1697756
RE: Impact of multiple user database files?

Ah. That makes all the difference in the world. I also see where I missed two key words in the original post. :blush: "per core".
Thanks for the feedback,...
--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)

March 17, 2014 at 10:09 am

#1697717
RE: Impact of multiple user database files?

To be clear, my response was based on the OP's claim of having a single file per filegroup. I absolutely agree that having a shedload of files per filegroup...
--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)

March 17, 2014 at 9:44 am

#1697703
RE: Impact of multiple user database files?

I guess I'll be alone in this. 😀 I don't believe it's necessarily a bad design at all.
First, having the 80 files won't degrade performance. It won't enhance...
--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)

March 17, 2014 at 8:54 am

#1697678
RE: Inserting values with SP

Sean Lange (3/17/2014)
Slightly off topic but you might look closely at what @@IDENTITY returns. Almost everytime I see this the person really wants the identity value from the insert they...
--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)

March 17, 2014 at 8:47 am

#1697673
RE: How to display stored procedure output in html table format using sql server 2000

mcx5000 (3/17/2014)
You could use this to produce simple html from a select statement:
declare @html nvarchar(max), @table nvarchar(max);
set @html =
N'<html><head><title>Doc Title Goes Here</title></head>' + CHAR(10)
+ N'<body style="font-family:...
--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)

March 17, 2014 at 8:46 am

#1697672
RE: Having fun with PARSENAME (SQL Spackle)

Great Spackle article on an underused function, Wayne. I'm not sure why it currently only has 3 1/2 stars. I gave it a 5 because it does just...
--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)

March 17, 2014 at 7:36 am

#1697630

Viewing 15 posts - 24,121 through 24,135 (of 59,102 total)