Viewing 15 posts - 15,016 through 15,030 (of 19,560 total)
lmu92 (4/9/2010)
CirquedeSQLeil (4/9/2010)
...And the State Security Annihilation Service doesn't bother asking questions - they just act.
That's where the QA (question asking tool) comes into play...
Ah yes, good point.
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
April 9, 2010 at 5:25 pm
lmu92 (4/9/2010)
CirquedeSQLeil (4/9/2010)
Is today Friday?It depends.
Over here in Germany is Saturday since over an hour. 😀
Gooooood morning SSCeeeeeaaaaahhh!
The forums are pretty quiet - I was checking for a heartbeat.
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
April 9, 2010 at 5:19 pm
lmu92 (4/9/2010)
Tom.Thomson (4/8/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
April 9, 2010 at 5:12 pm
Is today Friday?
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
April 9, 2010 at 4:34 pm
Aaron Prohaska (4/9/2010)
I just tried to install 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
April 9, 2010 at 4:30 pm
I have to admit that my memory served well on this one, but I doubted it. I went and looked it up - Google.
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
April 9, 2010 at 4:22 pm
Kiran gajendragadkar (4/9/2010)
jason .. There is no pain in your name 🙂
Can you name the movie from whence the quote originates?
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
April 9, 2010 at 4:20 pm
Clustering does provide a level of protection - even if you consider it just a High availability solution. It does cost more to implement than a standalone server, but...
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
April 9, 2010 at 4:02 pm
PrintKey
BeyondCompare
Notepad++
RedGate Toolbelt
TFS (VSS)
Password Safe
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
April 9, 2010 at 3:45 pm
Thanks Wayne. Nice article.
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
April 9, 2010 at 3:40 pm
Run a profile against your database.
You can try to run that sqlhandle provided in the error text against the query provided at:
http://sqlserver-qa.net/blogs/t-sql/archive/2007/10/04/2324.aspx
This should help you in learning about that kind...
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
April 9, 2010 at 3:18 pm
Yes Odd number of Board members. I don't think it should take more than three people though.
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
April 9, 2010 at 3:02 pm
Mani-584606 (4/9/2010)
Do you know the query that is being executed by the proc sp_executesql?
That proc is really what is being deadlocked. That proc is held inside the resource database and...
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
April 9, 2010 at 2:59 pm
Bhuvnesh (4/9/2010)
select * from sys.stats where auto_created = 0And what does this query mean ?
Word of caution. That view is SQL 2005. This thread is in...
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
April 9, 2010 at 12:50 pm
hennie7863 (4/9/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
April 9, 2010 at 12:48 pm
Viewing 15 posts - 15,016 through 15,030 (of 19,560 total)