Digs (1/6/2013)

---

First the code...

....

The result from the 1st SELECT is this:

201302201253201252201251

As you can see I am missing 201301

QUESTION: how can I fix this? I need YYYYMM in order.

PS: I...

Not WHERE clause, but HAVING, because you want filter out groups. Add after GROUP BY block HAVING Max(WQ.WorkQueueEndWorkDate))%3600/60)>=120

Remove set XACT_ABORT ON and implement TRY CATCH http://msdn.microsoft.com/en-us/library/ms175976%28v=sql.100%29.aspx, so this proc should looks like (I can't test it so first test it):

CREATE PROCEDURE [dbo].[proc_Master_Schedule]

...

What exactly is your problem? According to BOL "A view can be referenced only by an INSTEAD OF trigger." http://msdn.microsoft.com/en-us/library/ms189799%28v=sql.90%29.aspx

You could use linkedservers, openrowset http://msdn.microsoft.com/en-us/library/ms190312.aspx or openquery http://msdn.microsoft.com/en-us/library/ms188427.aspx

eg. openrowset SELECT * FROM OPENROWSET('SQLOLEDB', 'Server=HOSTNAME;UID=DB_USER;PWD=StronPassword;','select * table');

DB Owner dbo http://msdn.microsoft.com/en-us/library/ms178630.aspx.

DBO is like sysadmin on instance level, but only on a particular database level.

Yes you can, but first ask yourself if you really want/need this? Log growing is a very IO expensive process, and have huge impact on performance.

Actual statistics, yes. This is they purpose.

Bhuvnesh (1/4/2013)

---

When we do sp_recompile, sql optimizer destroy the existing and create a new...

They are totally different solutions. There are just a few similarities not a difference.

rchafei (1/2/2013)

---

Thank you for your quick response.

Sorry, I'm not clear on your question; so I'll give it a shot: the users change the data via windows user interface

I've actually considered...

Why in that way? Why don't you use backup and restore? Or you can make script for DB creation, with or without data from SSMS.

opc.three (1/2/2013)

---

A slight tweak to your second query will show you how similar OFFSET and TOP can be:

USE AdventureWorks2012

SELECT TOP 100

[TransactionID]

...

.CMD files with for loops and execute sql script by using sqlcmd, or more current and more powerfull PowerShell.

Have you ever cleaned backup history?

http://technet.microsoft.com/en-us/library/ms188328.aspx

exec msdb.dbo.sp_delete_backuphistory 'oldest_date'

raotor (12/12/2012)

---

Ninja's_RGR'us (12/12/2012)

---

There's only 1 valid test.

FULL restore, including diffs and logs.

THEN run checkDB.

Now you know you're good.

Once that's done you can't move the files because they could get corrupted...