Viewing 15 posts - 316 through 330 (of 832 total)
What sort of issue are you getting assigning different ports to each instance? So long as the SQL Browser service is running, the actual port each instance is on should...
July 2, 2012 at 4:52 am
I'm a bit annoyed with myself...I've read the linked article before, but I went ahead and clicked the "Full backup" option simply because that's what I would do in that...
June 28, 2012 at 6:24 am
The one problem with using KeePass is that it's fine if you're only ever using these passwords from the machine where your password database is stored. Becomes more of an...
June 28, 2012 at 6:14 am
Would using GROUP BY rather than DISTINCT work in this situation?
June 26, 2012 at 3:42 am
I'd agree with Michael--this question seemed to be unnecessarily obfuscated and was more about reading comprehension than anything SQL related, IMHO.
June 26, 2012 at 2:36 am
I'm pretty sure that doing a shrink immediately after an index defrag is utterly pointless, because it will fragment the indexes again--check the index fragmentation after you've done the shrink!
June 25, 2012 at 4:42 am
Hugo Kornelis (6/20/2012)
SQL Server itself does impose this limit. As specified at the link included in the explanation, SQL Server has a limitation of 32767 (the maximum value in a...
June 20, 2012 at 7:10 am
Koen Verbeeck (6/20/2012)
kibi - mebi - gibi - tebi - pebi is a multiplication of 1024 or 2^10.
That goes like 2^0, 2^10, 2^20 and so on.
And those are the numbers...
June 20, 2012 at 4:44 am
Silly question--you're not backing up both the full and transaction log backup to the same file, are you? A SQL backup file can contain multiple backups.
June 19, 2012 at 1:12 am
Your second table is qotd5, but you're still creating the unique index on qotd4--hence it's not too surprising you get all four results the second time, because there's no unique...
June 8, 2012 at 3:31 am
Looking at the answers, I guess a lot of people think IGNORE_DUP_KEY means it'll allow duplicates to be inserted--which, to be fair, actually makes sense from a strict English point...
June 8, 2012 at 1:10 am
Are you really creating 2 new tables for every new user who registers on your system? Seems you aren't going to need many users before you hit the 32768 objects...
June 7, 2012 at 7:10 am
dwain, Jeff said this was the expected behaviour in the article:
The following code generates a million rows of random integers (the SomeRandomInteger column) with possible values from 400 to 500...
June 7, 2012 at 1:12 am
Koen Verbeeck (6/1/2012)
Lucky guess for me 🙂
And an unlucky one for me... :rolleyes:
June 1, 2012 at 3:02 am
Viewing 15 posts - 316 through 330 (of 832 total)