Duplicate Post:

Please post your replies at http://www.sqlservercentral.com/Forums/Topic777289-1291-1.aspx

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)),

Case

datepart(dw, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)))

When 0 Then 'Sunday'

when 1 then 'Monday'

When 2 then 'Tuesday'

when 3 Then 'Wednesday'

When 4 Then 'Friday'

When 5 Then 'Saturday'

End

as Day

Refer - http://blog.sqlauthority.com/2007/08/18/sql-server-find-last-day-of-any-month-current-previous-next/

Edit - Duplicate post due to network issue

select so.name as table_name, si.is_primary_key from sys.indexes si

left Join sys.objects so on si.object_id=so.object_id

where si.is_primary_key=1

and so.type='U'

I made some changes to SQLBOT's code and it's giving me all table names where...

update mytable set datetimefld=convert(varchar, datetimefld,101)

Try with that code.

p.s. - i didnt test it.

No it's present. Click on the word This

query backupset table in msdb and see the frequency of backups happening for various databases.

This url from msdn side has a nice example of...

Mine has little issues. within forum it says 1566 and on the main page it says 1569 points... difference of 3 points...

Script out all objects of your database and ship the script to the customer.

Go through the articles that others have suggested.

Blocking can happen due to multiple reasons....

kumar99ms (8/25/2009)

---

Hi gail,

Thank you for your reply

Deleting T-log file it is not good right

we will shrink the file only

Is it possible to delete T-log file what happed ?

AS per...

Bhavin_Bhatt25 (8/22/2009)

---

------------------------------------------------------------

SELECT

Tran.Amount+Tran.Discount+Tran.Taxes AS [Nett]

--,[Nett] / 6.5 AS [Payable]

...

For the query you've mentioned, there cant be any performance improvement as Ian rightly said that all associated data pages will be read to return the resultset.

However, if you're concerned...

you can schedule it to run after business hours. Keep in mind that reindex will lock the base tables (users will not be able to run dml operations unless u've...