Viewing 15 posts - 8,431 through 8,445 (of 19,560 total)
Have you tried using localhost in your url?
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 30, 2011 at 12:29 pm
Daniel Bowlin (9/30/2011)
Theory of Relativity, under scrutiny....who'd of thunk it
And that is relative, why?;-)
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 30, 2011 at 8:52 am
Pravasis S (9/30/2011)
The only option I can think of is to reinstall sqlserver and then try again.
If you guys...
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 30, 2011 at 8:47 am
I would hope that MS gets that fixed soon!!
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 29, 2011 at 10:27 pm
As magoo has said, there are better methods for this type of query than a recursive cte.
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 29, 2011 at 10:15 pm
GilaMonster (9/29/2011)
SQLRNNR (9/29/2011)
Grant Fritchey (9/29/2011)
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan...
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 29, 2011 at 1:15 pm
Grant Fritchey (9/29/2011)
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's...
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 29, 2011 at 1:04 pm
@SQLFRNDZ (9/29/2011)
sql_novice_2007 (9/29/2011)
In fact I ran into space issue. Thats why I wanted...
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 29, 2011 at 1:03 pm
3 GB is a tiny database. Defrag and update stats.
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 29, 2011 at 11:34 am
This really seems like a permissions escalation issue with Vista.
There is nothing else that comes to mind that could be relevant from the SSRS side.
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 29, 2011 at 11:33 am
Lowell (9/29/2011)
does SQL 2000 support logon triggers? i think that's only 2005 and above, rioght?
Correct
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 29, 2011 at 11:32 am
Your browser is throwing an error for 1 of 2 reasons - memory leak or the query takes too long.
By fixing your datasets to eliminate parameter sniffing you are helping...
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 29, 2011 at 11:32 am
Rather than a new window - try it from a new tab - to eliminate permissions escalation issue.
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 29, 2011 at 11:29 am
There could be a memory leak being revealed when executing this report.
Other things you could try involve fixing the queries for the datasets to prevent parameter sniffing. Also, try...
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 29, 2011 at 10:48 am
My 2 bits - I like to use the method that Jack showed.
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 29, 2011 at 10:46 am
Viewing 15 posts - 8,431 through 8,445 (of 19,560 total)