Viewing 15 posts - 301 through 315 (of 479 total)
Hi
Dont forget jobs that are "still" running, ie. havent finished from when they where scheduled to run at 1am for example and its now 10am, this is a classic...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 19, 2002 at 9:58 pm
excellent points made, ill follow up on these and see how we go.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 13, 2002 at 2:27 am
ok,
a hint forced it through, but i dont like it ! 🙂
<delete stateent> etc with (index(ix_enrolment1))
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 11, 2002 at 3:01 am
Hi
Although fine, its all overally complex for a simple task. I can never understand why people use everything else (like SQL*DMO), vb-script, extended stored procs etc etc to do...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 27, 2002 at 8:30 pm
Hi
I confirm LSCHOLL's support fix, also, use the SQL*Agent GUI properties for managing the proxy where possible to aleviate some confusion in the process, and always re-connect you sessions before...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 11, 2002 at 10:48 pm
Ok
Worked it out. I was using an alias in the linked server to the other named instance on the same box, I altered this to the actual named instance...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 1, 2002 at 12:13 pm
Hi all
>>EFS and all SQL Server 2k encryption options for views, stored procedures etc utilises the Windows Crypto API.
This is incorrect. A number of high profile security sites...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 31, 2002 at 5:02 am
Hi
Search MSDN, then google, also see this website and sql-server-performance.com
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 24, 2002 at 9:52 am
YES, you are perfectly correct and I have been using this method with SQL*Probes assistance to monitor the problem tables. It seem a good method but you skill need...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 23, 2002 at 9:14 pm
sqldesigner,
I will need to re-verify under a full domain model, but I dont believe you are correct re the data recovery admin group etc. The encryption key seems to...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 18, 2002 at 10:38 am
Hi there
To honest, it was a very quick overview, and when i did I found the architecture somewhat confusing. Either way, I was convinced the key was part of...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 17, 2002 at 3:12 am
Hi
But isnt that the key benefit from clustered indexes? where high selectivity is not necessarilya key requirement, especially for range scans? the Y,N one is fair enough but...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 3, 2002 at 8:10 pm
Hi all
OK, managed to repeat it on our support server, but its very spiratic. We have a large query, the programmer was running it via query analyser and was...
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 2, 2002 at 6:58 am
Table has a clustered index?
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
July 1, 2002 at 9:39 am
Hi
Please post the MS article URL for reference..
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 30, 2002 at 7:31 am
Viewing 15 posts - 301 through 315 (of 479 total)