Viewing 15 posts - 46 through 60 (of 98 total)
As far as I know, no. This setting is exclusive to the SAN. SQL Server, as far as I know is not aware of this setup, and the refresh is...
December 5, 2012 at 7:43 am
While we dont use SRDF, and use a similar Hitachi product, we have a dummy job that runs every hour updating a single row in a dummy table. We use...
November 30, 2012 at 3:03 pm
I think you only need to change the SQL Agent service account, not the SQL Server service account.
November 30, 2012 at 1:48 pm
More likely that you will need to change the SQL Agent service account to a domain account that has access, not the SQL Server service account.
November 30, 2012 at 10:32 am
If the query just ran, the plan would still be cached and it should fetch that gluttonous query. If the SPID is still active and you know the #, you...
November 30, 2012 at 7:51 am
Use the data import wizard. Probably the easiest route.
Right click on database in SSMS, Tasks --> Import data. Its pretty obvious and self explanatory.
November 28, 2012 at 2:54 pm
No backups ? No recovery(At least I dont think so). But yes - in full recovery model, you could backup the log and do a point in time restore, provided...
November 28, 2012 at 10:04 am
There is no independent sequence generator or function. You can usse the identity property - by designating a column as an identity, you can have SQL Server automatically generate incremental...
November 28, 2012 at 9:52 am
Why do you need the if exists ? Why can you not just use a direct join with the same conditions ?
SELECT tf.*
FROM filesTA tf
...
November 28, 2012 at 9:47 am
While I dont know whats specifically going on in your case, a few more questions / suggestions come to mind, namely:
1. If you're using the old text / image datatype,...
November 28, 2012 at 9:15 am
Could there be something as silly as an open transaction that hasnt committed in this database ? A simple "SELECT @@TRANCOUNT " or a DBCC OPENTRAN should tell you.
The...
November 27, 2012 at 9:10 am
Never mind about the SQL - I just downloaded the rar file and was able to extract the .sql files.
November 27, 2012 at 8:22 am
This is getting really interesting. Can you please post the exact profiler trace of both ? (The read uncommitted and the read committed). This would obviously explain the faster run...
November 27, 2012 at 8:20 am
ricardomijares64 (11/23/2012)
Hello all. I would like to help me please. I need to monitor the inserts and transactions that...
November 23, 2012 at 2:15 pm
No comprende Espanol. Not sure if other spanish experts are around.
Any chance of posting this in english ?? 🙂
November 23, 2012 at 2:01 pm
Viewing 15 posts - 46 through 60 (of 98 total)