Viewing 15 posts - 10,126 through 10,140 (of 19,560 total)
excellent question. thanks
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
May 16, 2011 at 10:08 am
GilaMonster (5/16/2011)
SQLRNNR (5/16/2011)
Back to alphabet soup. I love the alphabet soup when the certification is mis-spelled (e.g. MCSE becomes MSCE or MCDBA becomes something like MCSDBA)Linky? Please?
No link -...
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
May 16, 2011 at 10:05 am
Back to alphabet soup. I love the alphabet soup when the certification is mis-spelled (e.g. MCSE becomes MSCE or MCDBA becomes something like MCSDBA)
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
May 16, 2011 at 10:00 am
good 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
May 12, 2011 at 12:20 pm
crookj (5/12/2011)
Ray K (5/12/2011)
WOTD: ""(As you can see, I don't have much to say today . . . ;-))
WOTD - Flashback (As in the earlier posts about the Sounds of...
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
May 12, 2011 at 7:59 am
I would check both ntfs permissions and share permissions. Is the share on a domain or is it on a computer that is not a member of a domain?
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
May 12, 2011 at 7:52 am
Info on my latest presentation - here.
It should be posted at some point for download and viewing.
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
May 12, 2011 at 7:42 am
Has the job changed?
I would suspect parameter sniffing and alter the proc for that.
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
May 11, 2011 at 1:33 pm
Are you trying to find which data exists in one table but not another?
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
May 11, 2011 at 1:30 pm
I agree with applemouth - it is a permissions issue of the account that is running the job. Test it with that account - verify permissions of that account.
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
May 11, 2011 at 1:27 pm
Thanks for another great resource in the series.
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
May 11, 2011 at 1:25 pm
Daniel Bowlin (5/11/2011)
SQLRNNR (5/11/2011)
smashingpumpkins
uh - oh. That is precisely the thought I 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
May 11, 2011 at 1:10 pm
Have you declared a table type matching your table variable definition?
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
May 11, 2011 at 11:15 am
Have the business requirements for data retention and when data should be archived been clearly defined?
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
May 11, 2011 at 11:10 am
I see no problem with DB Mail. It uses an SMTP server that you can specify. You can secure that smtp and specify rules there.
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
May 11, 2011 at 11:09 am
Viewing 15 posts - 10,126 through 10,140 (of 19,560 total)