Viewing 15 posts - 19,471 through 19,485 (of 19,560 total)
Something we have done in the past is to block apps at the firewall - if you have your database servers in a protected zone.
Another method is to disable 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
August 26, 2009 at 11:07 am
Ouch, have to agree with GSquared. That clustered index scheme should be re-evaluated by the vendor. Setting your fillfactor low and defragging will help this scenario.
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
August 26, 2009 at 9:26 am
Are you using a service account for the Browser service startup? If so, is that account expired, or password expired?
Also try from a cmd prompt:
ipconfig /flushdns
And then have 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
August 26, 2009 at 9:09 am
Hugo and Hakan, both bring up good points. There may be justifiable cases to not have a clustered index on a table - in an ideal world where one...
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
August 26, 2009 at 9:03 am
To answer your questions would vary from school to school and employer to employer. What are the hours like - depends on how well you do your job 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
August 25, 2009 at 9:55 pm
With the linked server in play, that is where I would troubleshoot first. You said that the proc does the import and export from within the same Instance, 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
August 25, 2009 at 6:23 pm
This is a decision to be made by the db and server groups within your company.
I prefer to separate SSIS off onto it's own server - we call them process...
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
August 25, 2009 at 6:19 pm
For those still asking, try the sqlfarms website. There is a script there to download. In order to download you must be a member of the site.
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
August 25, 2009 at 5:35 pm
RedGate also has a tool called Dependency tracker that could be of some 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
August 25, 2009 at 5:06 pm
Which version of Management Studio are you using and which version of SQL?
Are these connection issues related to trying to connect to SharePoint, WSUS or something like 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
August 25, 2009 at 4:53 pm
Personally I like ER Studio. Thanks to this listing, I am checking out Power Architect 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
August 25, 2009 at 4:48 pm
A couple of things to check:
Check in the SQL Server Configuration Manager > Network Protocols > Protocols
Verify that Hide instance is set to no
In SQL Server Surface Configuration Manager, make...
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
August 25, 2009 at 1:31 pm
To reiterate what Steve said, you will be able to re-use the log space when doing log backups. In full recovery mode, you should be performing t-log backups at...
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
August 25, 2009 at 1:20 pm
Nice article Gail.
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
August 25, 2009 at 12:41 pm
statistics courses and google search that landed the answer on the first return
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
August 25, 2009 at 12:14 pm
Viewing 15 posts - 19,471 through 19,485 (of 19,560 total)