Viewing 15 posts - 11,056 through 11,070 (of 49,566 total)
The error message tells you clearly that SQL doesn't have permission. You need to go to that folder and grant the SQL Server service account full rights to the folder...
November 6, 2013 at 4:36 am
Looks pretty clear
Could not open file D:\DB\Data\master.mdf for file number 1. OS error: 5(Access is denied.).
SQL doesn't have permission on the file, or probably the folder.
November 6, 2013 at 4:29 am
The plan isn't stored in XML, that's just how SQL gives it to you, not its internal representation.
You're talking about 120kB that will be stored in cache once per procedure.
November 6, 2013 at 4:27 am
SQL_Kills (11/6/2013)
Selectt1.warehouse,
t2.warehouse,
t1.product,
t2.product
From productOld t1 full outer join productNew t2
on t1.warehouse = t2.warehouse
and t2.product = t2.product
where
t2.product IS NULL
Is...
November 6, 2013 at 4:07 am
sej2008 (11/6/2013)
November 6, 2013 at 4:00 am
You can query sys.dm_exec_cached_plans, however I can tell you now there should be minimal difference. The differences you describe are in the T-SQL. The first phase of parsing converts T-SQL...
November 6, 2013 at 3:59 am
It's useful when you're about to make a bunch of changes that may need to be undone, for example a code deployment. Easier than restoring from a backup to undo.
November 5, 2013 at 11:54 pm
There's no snapshot involved in a backup, there's nothing that keeps track of changed extents during a backup process (other than the normal logging process) and changed extents are not...
November 5, 2013 at 10:50 am
Did you investigate and confirm that the cause of the original slowdown was TempDB contention?
November 5, 2013 at 6:52 am
Copying and restoring a backup can be automated probably easier than copying, plus all the other advantages of restoring a backup that have been mentioned.
November 5, 2013 at 4:11 am
Jeff Moden (11/5/2013)
November 5, 2013 at 1:43 am
If you have an instance that does have profiler, use the GUI to create the trace you want, then export the trace creation script. I don't know anyone who writes...
November 5, 2013 at 1:22 am
Use the server-side trace procedures (sp_trace_create and related). They're there even if profiler isn't. Or use extended events.
You can use profiler from any other edition to create the trace script....
November 4, 2013 at 11:49 pm
Pretty much the same way you do it in any other edition of SQL. There's nothing special about Express in that sense.
November 4, 2013 at 11:36 pm
Viewing 15 posts - 11,056 through 11,070 (of 49,566 total)