Viewing 15 posts - 18,901 through 18,915 (of 19,560 total)
This would be a nice feature.
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 7, 2009 at 9:48 am
GilaMonster (12/7/2009)
Steve Jones - Editor (12/7/2009)
OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspxBeautiful.
Yes, indeed. Most excellent.
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 7, 2009 at 9:47 am
GilaMonster (12/7/2009)
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too polite to...
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 7, 2009 at 9:39 am
Grant Fritchey (12/7/2009)
Alvin Ramard (12/7/2009)
Grant Fritchey (12/7/2009)
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
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 7, 2009 at 9:29 am
Alvin Ramard (12/7/2009)
Lynn Pettis (12/7/2009)
Bob Hovious 24601 (12/7/2009)
Now if they had said "Help me with this, please, Expert." that would have been another matter entirely. 😉
Maybe just a extra...
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 7, 2009 at 9:21 am
GilaMonster (12/7/2009)
Hmmm. Just got email from random SSC member. Starts "Help me with this" then goes on for 2 pages. Looked like homework too.Shift-Delete
LOL
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 7, 2009 at 9:18 am
There is an integral piece of information. Knowing that the server is clustered is essential information for the answer.
Using net stop net start for the services will cause 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
December 7, 2009 at 8:31 am
demise
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 6, 2009 at 5:09 pm
The article referenced is speaking of starting SQLSERVER.EXE from the command prompt, not stopping and starting services using net commands.
In the article, it discusses stopping the services using net commands...
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 6, 2009 at 5:04 pm
Should the line:
AND b.HC_STAFFID = isnull(@HC_STAFFID, b.HC_STAFFID)
be as is, or should it be the following?
AND b.HC_STAFFID = isnull(@STAFFID, b.HC_STAFFID)
I don't see a variable declared for @HC_StaffID.
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 6, 2009 at 4:55 pm
Nice catch Steve.
You will need to replace 'sa' with the Role for which you wish to grant access. As Steve stated, you should grant permissions to a...
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, 2009 at 8:32 pm
Yes, there are tools available. With our dts packages we see about a 50% conversion failure rate and have to manually do the conversion anyway.
One such tool that can...
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, 2009 at 10:22 am
Alvin Ramard (12/5/2009)
Jeff Moden (12/4/2009)
CirquedeSQLeil (12/4/2009)
You mean I can't run SQL Server on Knoppix and fail replication over to the subscriber on an as-needed basis?:-P:-D
Damn! I was hoping to...
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, 2009 at 10:06 am
alternatively, create a script that will concatenate the statement in a set based fashion
select 'grant execute on ['+ name + '] to sa'
from sys.objects
where type = 'fn'
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
December 4, 2009 at 5:39 pm
Since it is not guaranteed that all of the packages will properly convert, you will need to investigate the packages at the individual level. Are you sure that you...
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 4, 2009 at 5:28 pm
Viewing 15 posts - 18,901 through 18,915 (of 19,560 total)