Viewing 15 posts - 16,441 through 16,455 (of 19,560 total)
Molly Cary (3/15/2010)
Well I'm pretty sure it's the tempdb that's my problem, but no I haven't figured out what it is.
Tempdb will grow due to temp table usage, large sort...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:24 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:22 pm
Lynn Pettis (3/15/2010)
declare @MyDate1 datetime,
@MyDate2 datetime2;
set @MyDate1 = getdate();
set @MyDate2 = @MyDate1;
select @MyDate1 - 10; -- Works
select...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:18 pm
GSquared (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:06 pm
Alvin Ramard (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:05 pm
John Paul-702936 (3/15/2010)
What Lowell was telling is extract that matches my requirement
I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 12:01 pm
Alvin Ramard (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:59 am
This is actually a common misconception. As John said, you will need to create an index manually for each FK.
Also of worth, I covered this topic with a script...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:55 am
Lynn Pettis (3/15/2010)
Les Cardwell (3/15/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:51 am
Alvin Ramard (3/15/2010)
Paul White (3/15/2010)
Jim,Yes. Data warehouses are a totally different kettle.
It's normal for denormalization to be present in a data warehouse.
(Seriously, there was no pun intended.)
Absolutely. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:47 am
Paul White (3/15/2010)
Normalize 'til it hurts...de-normalize* 'til it works!
Agreed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:45 am
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:43 am
John Paul-702936 (3/15/2010)
Can someone please explain...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:40 am
I recommend the replace option that was provided.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:35 am
As an option, try the below changes.
;WITH Excpt
as
(
SELECT
A.DetailID,
A.ClaimID,
B.MCareNo
,Row_Number() over (Order by a.detailid) as RowNum
FROM dbo.udf_GetDetailsAsOfTaskListID(17, 0) AS A
LEFT JOIN dbo.udf_GetClaimsAsOfTaskListID(17, 0) AS B
ON A.ClaimID = B.ClaimID
WHERE...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 11:34 am
Viewing 15 posts - 16,441 through 16,455 (of 19,560 total)