Viewing 15 posts - 8,941 through 8,955 (of 49,571 total)
Check in SQL that the trace is not running. That is exactly the error you get if you try reading a trace file that is still being written to.
May 23, 2014 at 3:13 am
The trace is still running. Stop it first, then load the data.
May 23, 2014 at 2:59 am
Sounds about right. 32GB with 27GB free space is roughly 5GB of data. Backjups only back up the data, not free space, so the backup being around 4GB (allowing for...
May 23, 2014 at 2:27 am
Something switching recovery models after the backup? Check the SQL error log.
Edit: Also check the error log for messages indicating explicit log truncation (backup log with truncate_only). It may be...
May 23, 2014 at 2:22 am
Steve, can anything be done about shrills like this:
http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB recovery...
May 23, 2014 at 2:21 am
spaghettidba (5/23/2014)
SELECT ... INTO holds a schema lock on the source table that can end up blocking other processes.
It does not.
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRANSACTION
SELECT * INTO #SomeTable...
May 23, 2014 at 2:20 am
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question?
No, you get used to it.
May 23, 2014 at 2:14 am
sql-lover (5/22/2014)
.. due application design, is hard for me to isolate and test with actual parameters, so I replaced some of them.
Doing so could change the query's execution plan so...
May 22, 2014 at 11:36 am
You can't have a cursor in a view.
Maybe a stored proc, loop over the databases, insert the results into a temp table, query the temp table.
May 22, 2014 at 11:34 am
Matt Crowley (5/21/2014)
May 22, 2014 at 11:19 am
Table definitions, index definitions please.
Are the business users happy with the chance of getting incorrect results from this query from time to time?
And, what's the point of this?
AND (''='' OR...
May 22, 2014 at 11:16 am
What does the Total Server Memory counter look like?
May 22, 2014 at 11:08 am
Jeff Moden (5/22/2014)
I always thought that testing facilities would at least check a driver's license for proof of identity.
They're supposed to. Either fake IDs that are good enough for this...
May 22, 2014 at 8:36 am
Viewing 15 posts - 8,941 through 8,955 (of 49,571 total)