Viewing 15 posts - 12,601 through 12,615 (of 19,560 total)
Any that are interested, my UG is having another livemeeting on Sep 9, 2010 @ 6PM PST.
https://www.livemeeting.com/cc/UserGroups/join?id=C7N873&role=attend
Meeting ID is C7N873 (just in case you need it).
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 3, 2010 at 8:32 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
With a big phat I told you so
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 3, 2010 at 8:29 am
Interesting question with a bit of an 'It Depends' set of Answers.
Log Shipping would be affected if the database were set to log-ship first and then compression were enabled after...
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 3, 2010 at 8:18 am
Lynn Pettis (9/3/2010)
Gianluca Sartori (9/3/2010)
I had to leave...
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 3, 2010 at 7:56 am
You are attempting to run this against just one index or is a bunch of indexes (when you run it manually in SSMS)?
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 2, 2010 at 5:00 pm
WayneS (9/2/2010)
Click here for the latest Delimited Split Function.Then, it's just:
SELECT ITEMFROM dbo.DelimitedSplit8k(@val, ',')
Nice resource, Wayne.
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 2, 2010 at 4:56 pm
SQLBill (9/2/2010)
Great director.
Work from home three days a week.
25 paid days of time off.
Work laptop to use when working from home.
On call for one week once every two months.
Guaranteed...
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 2, 2010 at 4:27 pm
Alvin Ramard (9/2/2010)
Steve Jones - Editor (9/2/2010)
Alvin Ramard (9/2/2010)
BTW, we need one more emoticon. We need one for banging head against something.Isn't that WayneS's avatar?
I wouldn't call it an...
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 2, 2010 at 3:55 pm
Does the proc contain any sort of conditions to execute one query v. another query depending on the conditions?
This can cause multiple execution plans. For instace, MS Crm does...
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 2, 2010 at 3:53 pm
anand_vanam (9/2/2010)
FROM sys.objects o
JOIN sys.schemas s
ON s.schema_id = o.schema_id
WHERE o.type = 'U'
why we need "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
September 2, 2010 at 3:29 pm
Alvin Ramard (9/2/2010)
CirquedeSQLeil (9/2/2010)
Alvin Ramard (9/2/2010)
Steve Jones - Editor (9/2/2010)
I'd send them a business card. $100/hr, be happy to work over RDP and install SQL for you.
Steve, you left out...
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 2, 2010 at 3:26 pm
We're glad it is working for you now.
Congrats.
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 2, 2010 at 3:25 pm
Alvin Ramard (9/2/2010)
CirquedeSQLeil (9/2/2010)
Alvin Ramard (9/2/2010)
Steve Jones - Editor (9/2/2010)
I'd send them a business card. $100/hr, be happy to work over RDP and install SQL for you.
Steve, you left out...
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 2, 2010 at 3:25 pm
Slightly modified version of that same query
SELECT s.name + '.' + o.name
FROM sys.objects o
JOIN sys.schemas s
ON s.schema_id = o.schema_id
WHERE o.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
September 2, 2010 at 3:24 pm
I have been once and will be there again this year. I can definitely say that it is well worth the money.
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 2, 2010 at 2:49 pm
Viewing 15 posts - 12,601 through 12,615 (of 19,560 total)