Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,976 through 30,990 (of 59,101 total)

RE: Is 2GB physical Memory enough for SQL Server 2008 RTM on a Virtual Machine?

Mile Higher Than Sea Level (2/26/2012)
...just for the overhead of the VM swapping
It's been a while since I've actually worked with VM of any kind so it might no longer...
--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)

February 26, 2012 at 10:11 pm

#1451877
RE: Table Optimization for fast retrival

rvasanth (2/26/2012)
Hi,
I am using SQL Server 2008 R2.
I am having an table with 10M records (around 40 fields). If i fetch 1M records with simple...
--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)

February 26, 2012 at 9:59 pm

#1451873
RE: How do you restore a SQL database that is using full recovery mode?

eba.seller (2/26/2012)
I have read several articles and still haven't found the answer to this. Can anymore give me a step by step answer to my problem?
Search for "how to restore...
--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)

February 26, 2012 at 9:57 pm

#1451871
RE: Microsoft Certified Master

Awesome, Uwe!
--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)

February 26, 2012 at 8:20 pm

#1451866
RE: How to create default parameter for stored procedure dataset

Add the default to the parameter in the stored procedure itself.
CREATE PROCEDURE dbo.SomeProc
Parameter1 INT, --This has no default
Parameter2 VARCHAR(8000) = 'SomeValue' --This has a default of 'SomeValue'
AS
procbodyhere...
--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)

February 26, 2012 at 3:27 pm

#1451851
RE: WHERE Date Range

GilaMonster (2/26/2012)
Jeff Moden (2/26/2012)
Subsequent runs, even on so simple a problem, show what I'm talking about (you and I actually agree on this... optional parameters will always be a problem).
That...
--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)

February 26, 2012 at 3:17 pm

#1451849
RE: CSV Parameter in proc

faijurrahuman17 (2/25/2012)
Hi;
Here i use the DelimitedSplit8K Function and splitting the string.
DECLARE @TMP TABLE(TID INT,ITEM VARCHAR(MAX))
DECLARE @STR VARCHAR(MAX)
SET @STR='COL1=VAL1,COL2=VAL2,COL3=VAL3,COL4=VAL4,COL5=VAL5'
INSERT INTO @TMP
select * from dbo.DelimitedSplit8K(@STR,'=')
SELECT *
FROM @TMP
TID COLUMNNAME
1COL1
2VAL1,COL2
3VAL2,COL3
4VAL3,COL4
5VAL4,COL5
6VAL5
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)

February 26, 2012 at 2:20 pm

#1451847
RE: CSV Parameter in proc

Dave Ballantyne (2/26/2012)
But more than it not being good functionaly, it is very bad practice.
Ok... so what is the alternative best practice that you're offering?
--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)

February 26, 2012 at 2:14 pm

#1451845
RE: How to get the data month by month?

I prefer not using the PIVOT operator for many reasons including some that are performance related. Please see the following article for more information.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

February 26, 2012 at 2:06 pm

#1451844
RE: WHERE Date Range

GilaMonster (2/26/2012)
The point of the dynamic SQL approach is to have a number of plans for the specific combinations of parameters that are passed.
You example is a good one 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)

February 26, 2012 at 1:57 pm

#1451843
RE: Long Parameter Lists

I guess my take on such a thing (and it IS just an opinion, not an argument) is that if someone is passing "at least hundreds" in such a list,...
--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)

February 26, 2012 at 1:08 pm

#1451840
RE: WHERE Date Range

Gail has hit the nail I wanted to talk about squarely on the head in the following.
GilaMonster (2/26/2012)
While there are various T-SQL methods to allow those kind of queries 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)

February 26, 2012 at 12:10 pm

#1451835
RE: WHERE Date Range

GilaMonster (2/26/2012)
Honestly, if there are multiple optional parameters I would recommend either dynamic SQL or adding OPTION(RECOMPILE) if you're on SQL 2008 SP2 or above.
While there are various T-SQL...
--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)

February 26, 2012 at 9:44 am

#1451832
RE: WHERE Date Range

Jeff Moden (2/26/2012)
BSavoie (2/25/2012)
Actually I have many more search criteria. All are strings. Can I still take the simple approach or does that change things?
Thanks as always!
If that's the case,...
--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)

February 26, 2012 at 9:10 am

#1451829
RE: WHERE Date Range

BSavoie (2/25/2012)
Actually I have many more search criteria. All are strings. Can I still take the simple approach or does that change things?
Thanks as always!
If that's the case, I definitely...
--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)

February 26, 2012 at 7:41 am

#1451825

Viewing 15 posts - 30,976 through 30,990 (of 59,101 total)