Viewing 15 posts - 7,651 through 7,665 (of 19,560 total)
Ninja's_RGR'us (12/5/2011)
SQLRNNR (12/5/2011)
Anybody else notice the changes to the blog section?What blog section?
http://www.sqlservercentral.com/blogs/
The layout is different. The syndicated posts are being published much faster than the typical 8hrs 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
December 5, 2011 at 9:32 am
Ninja's_RGR'us (12/5/2011)
crookj (12/5/2011)
WOTD - Frigid8 Degrees at this time.... with wind chill at -15.....
Fridge, what's for lunch?? 😛
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
December 5, 2011 at 8:59 am
Nice work on this one Tom.
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
December 5, 2011 at 8:58 am
Anybody else notice the changes to the blog section?
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
December 5, 2011 at 8:55 am
slizam (12/3/2011)
Is it something error about reserved keyword?
The modified query that you posted does not have an error at all. Not sure what you are talking about now.
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
December 3, 2011 at 7:19 pm
Did you take a log backup or did you change to simple recovery?
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
December 3, 2011 at 4:36 pm
Exams (12/3/2011)
After giving an exam for SQL Server just heard that the total time that is allotted for the exam would be monitored.
If a candidate takes less time would...
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
December 3, 2011 at 4:33 pm
Phil Parkin (12/3/2011)
The originally posted query looked like this:
SELECT p.phoneno, mf6_telmn AS TelID, mf6_lcno AS Schedule, mf6_stad1 AS Address, StatusCd
FROM...
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
December 3, 2011 at 10:33 am
That is different than the -3 spid.
Post the error messages you are getting.
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
December 3, 2011 at 10:32 am
GilaMonster (12/3/2011)
Why did you remove the question? Just means that others with the same issue can't be helped.
That's kinda silly. Should have left the original question.
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
December 3, 2011 at 10:31 am
GilaMonster (12/3/2011)
slizam (12/3/2011)
SELECT p.phoneno, mf6_telmn AS TelID, mf6_lcno AS Schedule, mf6_stad1 AS Address, StatusCdFROM payphone p LEFT JOIN tbphonestatus s ON mf6_telmn=machno
WHERE mf6_telmn='02408348'
That query parses without error. Either...
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
December 3, 2011 at 10:10 am
I too have completed exams in under half an hour. I haven't had an issue with my certs.
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
December 3, 2011 at 8:16 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
December 3, 2011 at 7:49 am
Have a look at this article that shows how to do that
http://jasonbrimhall.info/2011/03/21/dedupe-data-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
December 3, 2011 at 12:46 am
Jeffrey Williams 3188 (12/2/2011)
Redgate's SQL Backup
Quest's Litespeed
Idera's SQL Safe
All of the above are good options,...
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
December 2, 2011 at 10:27 pm
Viewing 15 posts - 7,651 through 7,665 (of 19,560 total)