Viewing 15 posts - 241 through 255 (of 832 total)
I'm pretty sure you can't specify the entire three-part database name in a CREATE PROCEDURE call like that--if you change that to USE Test_DB and only specify the procedure name...
February 4, 2013 at 4:36 am
roger.plowman (1/30/2013)
However, the question now becomes, why *doesn't* it compress seperately stored data? If you're using data compression, you NEED it, and if your application makes extensive use of seperate...
January 30, 2013 at 8:32 am
Bit uncertain about the description of Isolation. Surely the whole point of record locking is that it DOES prevent the other transaction until the first one is finished? In your...
January 17, 2013 at 6:13 am
okbangas (1/15/2013)
But, there has not been any scan between the marking of ghost records and Ghost Cleanup Task, hence it has nothing to do.
I think that's a scan that's carried...
January 15, 2013 at 6:06 am
I wonder if this is a bug in SQL Management Studio, because I've seen the same behaviour myself--it always seems to be the bottom-most database in the list that "forgets"...
January 11, 2013 at 8:02 am
Couldn't you work it the other way round and use a connection to SQL from the Excel spreadsheet to populate its columns? Difficult to say how viable this is in...
January 9, 2013 at 8:48 am
It's been a while since I used the SQL addon for Backup Exec (think it was back in version 12 or thereabouts), but I never found it to work very...
January 8, 2013 at 4:15 am
No, none of this information is written into the event log. If you want to track user deletions you'll need to use the default trace, as you've found.
January 7, 2013 at 3:17 am
anthony.green (1/3/2013)
You could try adding the computer account in on the share permission, but never tested that so cannot confirm if it works or not.
I can confirm it *does* work,...
January 4, 2013 at 4:18 am
The SQL 2012 licensing reference guide available on the Microsoft site has this to say:
The SQL Server 2012 Developer Edition is a full-function version of SQL Server software—with all the...
January 3, 2013 at 4:56 am
Hugo Kornelis (1/2/2013)
When using sqlcmd.exe, I get different results - 123.000000 and 123.0.
Odd, I just tested it using SQLCMD and got the answers as listed in the question. Must be...
January 2, 2013 at 4:41 am
bitbucket-25253 (12/4/2012)
3. I can only guess, but was using a brand new lap top when submitting the question and typing the QOD rather than a cut and paste from...
December 4, 2012 at 8:22 am
I'm no expert, but couldn't the issues your application architect is seeing be due to all the NOLOCKs rather than the isolation level?
November 23, 2012 at 8:11 am
I'm a little confused. Surely the Disk Transfers/second counter in Performance Monitor will already be limited by the hard disk subsystem you have installed, so you can't use it to...
November 22, 2012 at 2:01 am
D'oh! I should have spotted that...if the intent was just to prevent the data that's actually being returned from changing, as I was thinking, that would already be covered by...
November 21, 2012 at 7:16 am
Viewing 15 posts - 241 through 255 (of 832 total)