RE: Variable uses an Automation type not supported in VBScript
I had to do a CINT on all integers coming it ... an ODBC data conversion issue. Thanks for your replies.
2004-09-23
dynamic data masking
Fragmented index list.
Does anyone have a script that can be executed that will show which indexes are becoming fragmented? I am just starting to try and be proactive on a new highly visable SQL Server database that just went into production. I cannot seem to find much other than running the DBCC Showcontig report for each tbl/index.
2004-09-22
1 reads
RE: Space requirement for Re-indexing.
Thanks a lot Bill, That would definetely help. I will try to push to get additional 200GB.(Considering some growth factor.)
2004-09-22
RE: dtsrun would not die
If you have not done so already, you should try bouncing the service "MSSQLSERVER". That will usually clean up processes like that.Jeff
2004-09-22
RE: Performance required on > 4 million records
Colin,Would you give us the DDL of your tables and the query itself. Besid each table it would be good if you could indicate the number of rows it contains, as well as the indexes it actually has.So it will be easier for us to see where we have to look for
2004-08-16
problem in oracle about encyription decryption
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-08-09
RE: Database Change Management Best Practices : Achieving an Automated App
Go to www.innovartis.co.uk and get the whitepaper.
2004-07-28
RE: Failed to reserve contiguous memory
Hi Anne,I found this on the Microsoft web site, although we get a State of 14 but have also had State of 17.Hope it helpsColinFIX: JDBC Driver Leaks Server CursorsApplies To SYMPTOMSThe Microsoft SQL Server 2000 Driver for JDBC does not close server cursors that it opens under some conditions. This can cause cursor build […]
2004-07-21
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers