Viewing 15 posts - 32,191 through 32,205 (of 49,552 total)
There's no good reason to install client tools on a server at all. Connect to the server from your workstation, put the client tools on the workstation, not the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 5:30 am
Store the hash of the password, not the password itself.
http://msdn.microsoft.com/en-us/library/ms174415%28SQL.100%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 5:27 am
Please have a look this before you go ahead.
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 3:10 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 3:08 am
Oracle_91 (6/26/2010)
If am using all the CPUs then does it effect the overall performance of the sql server??
Yes, it can run queries faster because it has more processing power available...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 3:03 am
yessen (6/25/2010)
Backed up database fully.
Shrinked log file using DBCC SHRINKFILE.
checked VLFs, now only 4.
Set auto-growth to 5gb.
backed up log file, it is only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 2:58 am
rew-370421 (6/25/2010)
SQL log shipping is not an option available to me. So I have to do this myself.
Why is log shipping not an option?
You'd need to restore the full backup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2010 at 2:55 am
There's no log kept. You can check the default trace, if it hasn't rolled over (it keeps 5 files of 20 MB only). If you want to track this kind...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 3:23 pm
You'd need to restore the full backup either WITH NORECOVERY or WITH STANDBY in order to restore further transaction logs. The logs will need to be restored with the same...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 3:22 pm
Nope. That's what the cert exams were like about 8-10 years ago. Not any more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 2:48 pm
mark.dba (6/25/2010)
It just seems like very inefficient way to do this.
It's the only way to do it. There's no way to downgrade a database (2008-2005). System tables, page layout,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 1:33 pm
Steve Jones - Editor (6/25/2010)
Plus aren't there all sorts of extra footsie ball fans clogging the country now?
Unfortunately yes. They'll be gone in just over 2 weeks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 9:31 am
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.
So come down my way. Only 20 hours of so of flying and the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 9:25 am
yessen (6/25/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 9:24 am
@@Trancount returns the current transaction count for that connection.
@@rowcount returns the number of rows affected by the last statement that ran on that connection.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2010 at 9:11 am
Viewing 15 posts - 32,191 through 32,205 (of 49,552 total)