Viewing 15 posts - 44,656 through 44,670 (of 49,571 total)
The only time you can use a snapshot like that is if you have database mirroring. Providing the mirror DB is synchronised (note, synchronised, not running in synchronous mode), then...
September 8, 2008 at 8:29 am
What's the purpose behind this? Redesigning a database that's in use is not something that I see done often. It can require a lot of time and money and, unless...
September 8, 2008 at 8:25 am
LaTeX - it's a document markup language that's used extensively in academic fields. Based on TeX
Timothy: Personally I'd just use a verbatim block, then you can format it any way...
September 8, 2008 at 8:22 am
You can take backups of the log of a database that's used for replication as long as the DB is in full recovery mode. No problems there
The log shipping requires...
September 8, 2008 at 8:16 am
You can. Whether it will be useful or not is another matter.
September 8, 2008 at 8:10 am
I'll be blunt, as usual.
Dumps are cheating. Get your hands on one of the training kits for the exam and work your way through it. People cheating their way through...
September 8, 2008 at 8:05 am
Sorry, I didn't understand that. Could you please explain a bit more what you're trying to do?
September 8, 2008 at 1:33 am
Could you be a little more specific on what you want please?
Next time, please post in the appropriate forum, not an article discussion forum.
September 8, 2008 at 1:03 am
Turn autoshrink off!
Autoshrink doesn't just shrink the log file, it shrinks the data file as well. Shrinking data files causes index fragmentation. The next time data gets added, the data...
September 8, 2008 at 12:56 am
Personally, I've always preferred using perfmon for checking SQL's memory. I just don't trust task manager.
I just tested out on my desktop (Vista 64 running SQL 64 bit) Task manager...
September 7, 2008 at 3:46 am
Which is what the test with the read uncommitted shows.
If the isolation level is read committed or higher, and SQL has to scan the index it will scan in index...
September 6, 2008 at 9:19 am
For proof of what read-uncommitted does to ordering...
(borrowed and slightly modified from WesleyB's old blog
CREATE TABLE tblClustered
(ID int,
MyDate smalldatetime,
TestField char(2000))
GO
CREATE CLUSTERED INDEX ixID ON tblClustered (ID, MyDate)
GO
DECLARE @i int
SET @i...
September 6, 2008 at 8:59 am
However, even if the index hint is specified, there are ways to mess up the pseudo-ordering.
Parallelism (parallel scans and the subsequent repartition/merge streams return the data in no particular order)
Read...
September 6, 2008 at 8:46 am
I'm going. Second summit in Seattle.
There's a very good Thai restaurant in a shopping center a couple blocks from the conference venue. I don't recall the name, it's the same...
September 6, 2008 at 5:13 am
Viewing 15 posts - 44,656 through 44,670 (of 49,571 total)