quote: 1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information from the audit table, which was changed at the same time the view was put together, and join the data, which was then out of sync. As […]
2003-07-31
Thanks again for replying. 1. I originally wrote it as a single select. Unfortunately, the view has nolocks so SQL Server would put together the view first and then get information from the audit table, which was changed at the same time the view was put together, and join the data, which was then out […]
2003-07-31
Here is another way. select DAY(DATEADD(d,-1,DATEADD(m,DATEDIFF(m,0,GETDATE())+1,0))) The bennifit is it is just a bit shorter and requires replacing only 1 GETDATE(). Or this which is even shorter select DAY(DATEADD(m,DATEDIFF(m,0,GETDATE())+1,-1)) -1 represents 12/31/1899 and since the maximum number of days in a month is 31 if less then it will give you the highest value for […]
2003-07-14
I currently have log shipping setup and running in my production environment, and it is doing exactly what you are wanting to do. I used the procedure in the following link to set this up: http://www.sql-server-performance.com/sql_server_log_shipping.asp Dave Gradoville, MCDBA
2003-07-09
Greg, What's the best way of making your code dynamic? I tried declaring a variable so that the query became: declare @n int set @n = 76 select top 1 salary from (select top @n employeeId from employee order by salary asc) a order by salary desc but SQL Server doesn't like it. I can […]
2003-07-08
1 reads
hi, taken directly from BOL, "For example, to bulk copy data from the Authors.txt data file to the authors2 table in the pubs database, specifying that the data file is in ascending order on the au_id column, execute from the command prompt: bcp pubs..authors2 in authors.txt -c -t, -Sservername -Usa -Ppassword -h "ORDER (au_id ASC)" […]
2003-07-08
1 reads
In a previous reply I did indicate that there was a BEGIN TRAN on the first connection before the first Insert. And I believe you are right that just closing the recordset might be enough to prevent the second connection from being created. I observered the second connection in Query Analyzer while the app is […]
2003-07-02
Thank you very much mccork & 540... (whatever!!:-)) I can put all the "CREATE PROCEDURE's" in the same script?? JW
2003-06-30
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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