Viewing 15 posts - 19,336 through 19,350 (of 19,560 total)
Kalyan-539179 (9/17/2009)
HiIt is for SS2000 and SS2005
Thanks
They are microsoft solutions that will support the various flavors of SQL Server as well as other Microsoft products (it would be akin 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
September 17, 2009 at 11:37 am
Kalyan-539179 (9/17/2009)
Hi allCan anybody suggest me how to patch my sql server with latest updates ?
I am looking for step-by-step procedure to apply patches.
Thanks
A couple of options are:
Use SMS
Use...
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 17, 2009 at 11:17 am
What is your frag % immediately after a defrag? As suggested in the other thread, how many pages do you have in these indexes? What is your fillfactor?...
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 17, 2009 at 11:10 am
When you execute it manually, does it produce any warnings?
Also, are there any other inserts happening inside this proc?
Lastly, inside the sql agent job, what is the command you use...
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 17, 2009 at 11:02 am
Lowell (9/17/2009)
also SQLRecon; it uses a combination of different techniques to find all the registrations, their versions, and more...even identifies blank "sa" password installations.
As lowell has mentioned and from your...
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 17, 2009 at 10:53 am
This one made me pause for a sec - i was sure there was a trick somewhere in it (an extra space, some syntax or something). But straightforward 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 15, 2009 at 9:51 pm
K - so that drives more towards having a lookup table for the fiscal month dates (my opinion).
So what all have you tried to make the summing of months work?...
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 15, 2009 at 1:55 pm
What have you tried so far for the fiscal month solution?
Is the list of Fiscal Months static from year to year? If yes, you could potentially hard code those...
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 15, 2009 at 1:40 pm
The tempdb data file should be set statically and use the filegrowth as an emergency backup. When trying to determine what could cause it, you could look into 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
September 15, 2009 at 1:31 pm
I remember all too well what I was doing on that day as well. It was a very surreal experience watching it all day every day for so long....
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 11, 2009 at 10:04 am
GabyYYZ (9/10/2009)
Kit G (9/10/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
September 10, 2009 at 10:36 am
ooooh oooh
Why did brave Sir Robin turn about and valiantly chicken out?
Alternatively; If a train leaves Juneau AK heading due East, and a Train leaves Quebec heading due west. ...
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 9, 2009 at 5:07 pm
That is good information.
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 9, 2009 at 4:26 pm
running is great - how many miles?
I enjoy running - sick, hurt, tired, rain, snow, sun but not so much in the wind.
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 9, 2009 at 4:24 pm
Alternative method
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT',
N'ObjectName',
@ServiceAccount OUTPUT,
N'no_output'
SELECT @Serviceaccount as SQLAgent_ServiceAccount
Same principle
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 9, 2009 at 4:22 pm
Viewing 15 posts - 19,336 through 19,350 (of 19,560 total)