-- There is no problem with it, except the fact that it will keep getting bigger, until you re-initialize the file. I usually take log backup in to separate files and delete it after moving to the tape -- You can create the database if you want to before restoring but you have to choose […]
2003-07-25
One way is to import the file into a temporary table and then process that temporary table to insert or update records in the master table. Depending on how complex the data is, you might get away with a simple insert statement: insert <master_table> select <col1>, <col2> from <temporary_table> where not exists (select * from […]
2003-07-25
People always cheat. You can't prevent it, though honestly we never discussed this. We tend to operate in a real time environemnt and assumed most everyone else would. We're a community and we have that level of trust among us. If people cheat, I'd like to think they'd get caught at some point. Perhaps we […]
2003-07-24
1 reads
Try this instead CREATE Procedure p_get_customerdetails /* Param List */ @Customer_ID int, @view Int =0 AS Set NOCOUNT ON /* 0 = CustMain 1 = Devices 2 = Setup 3 = trxHist */ IF @view = 0 BEGIN SELECT * FROM vw_CUSTOMER WHERE CustomerId = @Customer_ID RETURN 0 END IF @view = 1 BEGIN SELECT […]
2003-07-23
quote: Right 🙂 But I was doing it as a counter-example. You have a 'valid' login but you cannot login. Hence you cannot execute your SELECT. So there, Answer nr 1 does not work. I'm assuming you tested this. Out of curiousity, did you add your login to master as a user before blocking guest […]
2003-07-16
2003-07-14
2003-07-14
SQL Server will only create these pseudo indexes if you have the 'Auto Create Statistics' option set on. You probably have the option set on for the database with 250 indexes, and set off for the database with only 7 indexes.
2003-07-11
Here we have lots of servers and are always getting new apps. HOWEVER, they are mostly small and they are of little impact. And most people don't do the testing. We've tried to change that, but quite often the decision has been made far above me to move this into production, so we work with […]
2003-07-10
1 reads
Yes - agree with GuardData - closing the rocordset ought to release any locks it is holding - in some configurations of the lock- and cursor- type parameters, the rst will act like a scroll cursor, holding a lock on the current record, or even all the records, until you close it. quote: We did […]
2003-07-01
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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