Viewing 15 posts - 8,491 through 8,505 (of 19,560 total)
drew.allen (9/28/2011)
SQLRNNR (9/28/2011)
It appears there is an issue with how SQL handles dates that land on Sunday.
Actually the problem lies with this piece of code:
DATEADD(wk, DATEDIFF(wk, 0, GetDate()), 0)
Similar code...
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
September 28, 2011 at 10:32 am
thang_ngo_2002 (9/28/2011)
But how can I define which login with correct password, which login with...
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
September 28, 2011 at 10:30 am
Sean Lange (9/28/2011)
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
September 28, 2011 at 10:16 am
WayneS (9/27/2011)
Steve Jones - SSC Editor (9/27/2011)
WayneS (9/27/2011)
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
September 28, 2011 at 12:34 am
It looks like Dereks chess algorithm needs an update. :-D:-D:-D
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
September 28, 2011 at 12:32 am
Good luck and may the plane be with you.
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
September 28, 2011 at 12:30 am
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
September 28, 2011 at 12:22 am
dileep41011 (9/28/2011)
what type changes required, plz suggest me, I am fresher
As I said - I already noted it once. Maybe this is another good reason to hire a consultant....
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
September 28, 2011 at 12:15 am
Kingston Dhasian (9/28/2011)
DECLARE @from_date DATETIME
SET @from_date = '11-Sep-2011'
SELECT CASE
WHEN DATEADD( MONTH, DATEDIFF(...
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
September 28, 2011 at 12:13 am
yubo1 (9/28/2011)
You can use 'set datefirst 7' to set sunday is the first date of a week in you sql-query
That wasn't working in this query. Only Sunday...
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
September 28, 2011 at 12:11 am
It appears there is an issue with how SQL handles dates that land on Sunday. Here is a klugy workaround.
DECLARE @from_date DATETIME
--Set DateFirst 1 --tried this but it had...
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
September 28, 2011 at 12:10 am
dileep41011 (9/27/2011)
plz help me
See my last reply where I provided the answer (the change needed to make Seans query work for you).
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
September 27, 2011 at 11:58 pm
Please provide sample data so we can test solutions.
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
September 27, 2011 at 11:56 pm
Does the Rooms table have arrival dates and departure dates? You could also try throwing on the where clause:
or ClientRoom.ArrivalDate is null
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
September 27, 2011 at 11:26 pm
dileep41011 (9/27/2011)
its query produce left node = 0 and right node = 15, while left node will be 2 and rightnode will be 13
The fix for that is quite simple....
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
September 27, 2011 at 11:20 pm
Viewing 15 posts - 8,491 through 8,505 (of 19,560 total)