After nine months of subscribing to this site. This is my first reply to a post. That was awsome!! I ran each part of the script independently and I still trying to grasp the entire concept. Can you explain spt_values, I attempted to use sp_helptext and the general bol and didn't find it. Thanks
2004-08-11
I've not hit the magic billion but I have done 100's millions.I used to take the production server down for a morning when I did it.My approach was as followsCalculate the size of the table to be copied. See BOL and in the index type "calculating table size" the top three entries are the valid […]
2004-08-05
2004-08-02
Hi, Thanks for your reply. I backup the database weekly. What I want is a updatable standby server. My version is standard and replication cannot meet the requirement perfectly (for example, restriction on 'text', 'image' fields). So I am thinking to copy the database to another machine every day. If the server is down, user […]
2004-07-08
I think that they used -1 as this is the value for True in MS Access and in Visual Basic. Indeed, it seems that SQL Server 2000 behaves differently (more correct, if I may say) than SQL Server 7. But you can use sp_dbcmptlevel to simulate the SQL Server 7 behaviour:if exists (select * from sysobjects […]
2004-07-03
I apologize in advance -- I have seen this answer (or one like it) in several areas and I assume it makes sense. I simply don't know what it means. Where are the registry keys and how do I give ASP.NET access to them?Will un/re-installing Reporting Services "break" anything else?Thanks!
2004-06-18
2004-05-26
Hi sunil, If you think of executing the Stored Procedure(SP) during the Windows startup then it is wrong thing to do. B'coz the SQL Server has to start for running your SP. But don't worry there is a solution for running the Stored Procedure when you start the Microsoft® SQL Server™. Use "sp_procoption" for setting up the SP for Autoexecution. This […]
2004-03-13
2004-03-11
Oracle can use casts to convert dates as well.oracle doesn't have a datatype called datetime. OpenQuery is executed as a passthru query on the remote server. Thats why you are receiving a ora- error. Try removing the cast specification.
2004-02-27
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers