Viewing 15 posts - 31 through 45 (of 60 total)
<< RandyB - Which specify performance objects and counters where you monitoring?
We use Spotlight on SqlServer by Quest Software. I believe they are using Page Faults/second which is under...
June 3, 2004 at 10:42 am
Our production server runs sql7 only on win2k with 2GB of memory which was dynamically allocated. However, I noticed that the server was paging at a high rate much of the...
June 3, 2004 at 9:25 am
<<
The other option, if you have only one account that developers use, is to make that account the owner of the development database using sp_changedbowner. The tables will be owned...
May 19, 2004 at 12:49 pm
<<by specifying dbo.objectname, this object will be created under dbo and owned by dbo.>>
The problem here is that our developers create tables in EM, not with a CREATE TABLE dbo.Tabl and that...
May 19, 2004 at 11:16 am
Why not:
SELECT COUNT(*), Surname FROM Employees
GROUP BY Surname
HAVING COUNT(*) = 1
March 4, 2004 at 11:40 am
NEVER MIND!!!
After further review, the job step was pointing to master db.
February 18, 2004 at 9:03 am
Very helpful everyone, Thanks.
Mark, that login script didnt post.
February 6, 2004 at 12:41 pm
The process is WINLOGON and seems to indicate any data copying or transferring outside of sql.
January 28, 2004 at 5:58 am
Typical 9AM log bkps are 10 - 30MB.
It just seems odd to log a transaction when sql is just moving data pages and index pages without changing any data rows;...
January 8, 2004 at 10:50 am
Do you mean the physical size of the database or the amount of data within the database?
I was referring to the data within. I backed up the database...
December 16, 2003 at 1:38 pm
Allen you got me thinking.
I am looking at the number of versions of these DTS packages and some of them number over 30. I am deleting all but 2 versions...
December 16, 2003 at 12:58 pm
Do you create many DTS or large DTS packages?
We have 188 DTS packages most of them small.
December 16, 2003 at 12:07 pm
NO - Do you have replication set up?
NO - Log shipping?
NO - MAster/Target Servers?
Check how many records in following tables.
862 - sysjobhistory
0 - restorehistory
1,149...
December 16, 2003 at 11:09 am
I may try the BCP solution as I have several more test tables that need reduced.
I am also thinking of scripting my indexes and dropping them, deleting the rows all...
December 5, 2003 at 8:34 am
Thanks for all the responses.
I'm running SQL7.
The Delete task rolled back after 3 hours and the net result was zero rows were deleted.
Therefore, I deleted the 3 years of...
December 5, 2003 at 6:54 am
Viewing 15 posts - 31 through 45 (of 60 total)