Viewing 15 posts - 76 through 90 (of 153 total)
"awaiting command" means the process is waiting for the application.
Either the application is busy doing some large calculation or it is waiting for user input during a transaction. I...
October 10, 2003 at 9:14 am
We keep the log backups for two days. Nobody will ask for a point in time backup for yesterday, but I like to have an alternative if the...
October 9, 2003 at 7:57 am
dekesc,
8.00.760 is service pack 2.
It seems you also have a MSDE server on your PC, and you upgraded that and not your developer edition.
You must still install the Sql2ksp3.exe service...
October 9, 2003 at 7:31 am
Right.
To check you can try the statement <code>select @@version</code> in query analyzer.
It should give version 8.00.818
The properties of the server in enterprise manager also give the SP number.
October 8, 2003 at 4:39 am
Always run update statistics automatically, with auto update or a maintenance plan for the reason Frank gave. It will update all created statistics. I prefer the maintenance plan as...
October 8, 2003 at 4:25 am
You where right in asking again.
Could you install Sql2kdesksp3.exe? The name does not cover the usage. It is not the service pack for sqlserver on a desktop, it is...
October 8, 2003 at 2:19 am
As far as I know there are the following issues:
Some system tables are gone or changed. If you application does not access them directly you will have no problem.
There...
October 7, 2003 at 7:11 am
Data components is the normal service pack, Sql2ksp3.exe that you already installed.
Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you...
October 7, 2003 at 6:51 am
I also thought the two should be about equal, but if you get "not enough memory to execute query", you clearly have not enough memory. Have you looked at...
October 7, 2003 at 5:55 am
You can see where a process is waiting for in the columns lastwaittype and waitresource from master..sysprocesses.
If it is waiting for a lock you can get more info from master..syslockinfo
I...
October 3, 2003 at 4:24 am
quote:
This prevents a single point of failure on the transaction logs because it is written to two log files on different drive...
October 3, 2003 at 3:55 am
quote:
Why is the Microsoft SQL Server development team not responding? Where are you, guys? Other SQL Server product...
October 3, 2003 at 3:09 am
No.
Diffential backups are data backups. It is the whole file or nothing.
stopat only works with log backups
September 25, 2003 at 4:12 am
Viewing 15 posts - 76 through 90 (of 153 total)