Books Online. The provided documentation on SQL Server. You can get an updated copy at: http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-10
1 reads
Go back and check the SQL Server logs from the time of the power outage and you can verify if SQL Server was shutdown gracefully. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-10
2 reads
I guess it is because VB is still considered an easy-to-learn language. There are countless sites with free code around, but I agree that when you need to solve a specific not every day issue you're pretty much on you're own. As it seems that SQL Server goes hand in hand VB or its dialects, […]
2003-12-10
1 reads
Thanks for all the posts and information. It's been very informative. After more experimenting, the NOT EXISTS runs about 8 times faster on average. Seems the larger the number of rows in the 'NOT' side has a much bigger impact on the 'NOT IN' than the 'NOT EXISTS'. Now it's off to BOL, what the […]
2003-12-09
Besides Antares686 constraint which will guarantee data quality, you could write your procedure as insert into Table_Name VALUES (@id,@value1) Where Table_ID <> @ID IF @@ROWCOUNT = 0 Return = - 1 --insert Failed ELSE Return = 0 --Success That way you are using the procedure for BOTH checks and inserts!! HTH
2003-12-08
Sort of sounds like there is an issue with the SQL server account not the sql agent account. Do any other accounts work against the SQL server ? Perhaps see if there are any differences between them and the one you are trying to use ?
2003-12-07
1 reads
Is this the kind of thing you are after? create table #temp (name varchar(50), Code varchar(50), CodeDesc varchar(50), Jan int,Feb int) set nocount on insert into #temp values ('JohnGinglehim', '45','Sick', 16, 0) insert into #temp values ('JohnGinglehim', '50','Vac', 0, 8) insert into #temp values ('HerrSchmidt', '45','Sick', 0, 8) insert into #temp values ('MasterJohns', '50','Vac', 8, […]
2003-12-05
All, Ok, we've traced the problem to the fact that the servers system date format changed when it was shutdown & restarted, i.e was 'dd/mm/yy' prior to shutdown and 'mm/dd/yy' after the restart. Everyone swears that no-one modified this setting manually, so i guess we chalk this one upto big Bill G & Microsoft undocumented […]
2003-12-05
quote: when opening a page I already start scrolling down before it is complete. When it completes, it scrolls to top. Can you avoid that? Unfortunately tat is a no. The scroll is handled by the environment and your browser itself is doing that to you.
2003-12-04
I resolved this issue. Problem was, when replication creates conflict table it creates a column called 'reason_code' and I was trying to publish a table which already has this column name. I renamed the column and now everything is fine.
2003-12-03
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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