Viewing 15 posts - 46 through 60 (of 1,270 total)
SQL Profiler doesn't need access to the internet. It only needs access to the SQL Server. Your interface will be different from what I described. I haven't worked regularly with...
May 10, 2014 at 6:02 pm
1. Open the SQL Profiler tool
2. Connect to the server
3. Check Show All Events and Show All Columns
4. Deselect any pre-selected events
5. Expand Objects
6. Select Object:Altered event
7. Go back to...
May 10, 2014 at 4:36 pm
Databases don't get set to single-user because a restore fails. It was probably set to single-user as part of the restore process because restoring a database requires sole access to...
May 10, 2014 at 4:08 pm
Pavan.g (4/20/2014)
Does Mirroring Break if we stop and start the Endpoints!!!!!!?????
It doesn't break. It will stop running when the endpoint is stopped and start running again when it is restarted.
April 20, 2014 at 1:31 pm
SQLHA (4/15/2014)
As ... someone many think of when it comes to clustering SQL Server.....
I can attest to this. If I made a list of the best clustering experts, Allan would...
April 15, 2014 at 4:34 pm
in terms of best practices, your tempdb is definitely in need of some configuration changes, but this is not one of them. I recommend reading my whitepaper on tempdb and...
January 14, 2014 at 10:26 am
Are you seriously concerned with a 259 MB log file? That's tiny. Leave the poor little guy alone.
January 14, 2014 at 9:53 am
My first recommendation would be to upgrade to 64 bit. Preferably on Windows 2012.
January 3, 2014 at 11:04 am
Plagiarism sucks. Here is a query I wrote to determine the best order for restoring backups to bring a database current. You can find the full post for the query...
December 4, 2013 at 11:23 pm
One thing you can do is to give the new instance an optimistic amount of memory (more than it can use) and then monitor to see how much it actually...
November 24, 2013 at 2:12 pm
Use sys.fn_xe_file_target_read_file() to read the file in from SSMS to output its data and query it like a table.
November 24, 2013 at 2:07 pm
I'd say that it depends on where the convert_implicit is. If it is converting a column used in the join or where clause, it could have a much bigger impact...
November 24, 2013 at 1:52 pm
A good starter is Troubleshooting SQL Server - A Guide for the Accidental DBA by Joanthan Kehayias and Ted Kreuger. You can buy a printed version on Amazon or get...
November 24, 2013 at 1:46 pm
Is your service account in DomainQ or DomainX? Everything has to be in the same domain for Kerberos to work including the user connecting.
November 24, 2013 at 1:40 pm
Viewing 15 posts - 46 through 60 (of 1,270 total)