Viewing 15 posts - 7,246 through 7,260 (of 49,571 total)
Jeff Moden (11/19/2014)
My thought would be that you're spending a whole lot of time on something that might not help.
In this case I'd disagree. Serialisable, when used unnecessarily, can easily...
November 20, 2014 at 1:23 am
How you decrypt it is completely dependent on how it was encrypted in the first place.
p.s. Passwords shouldn't be encrypted, they should be hashed (cryptographic one-way hash) with a salt
November 20, 2014 at 1:22 am
Your table is too wide. The fixed length columns in a table (data types other than varchar/nvarchar) cannot exceed 8060 bytes total. Your table is so large that adding the...
November 20, 2014 at 1:19 am
phil_mw60 (11/19/2014)
Although I understand that Check DB automatically creates a database snapshot when running in multi-user mode?
Yes
Will the following solution require me to place the DB into single user mode?
Run...
November 19, 2014 at 12:26 pm
Yup, something is dropping and recreating the table.
November 19, 2014 at 12:23 pm
cphite (11/19/2014)
GilaMonster (11/15/2014)
cphite (11/14/2014)
What purpose does making it mandatory actually serve?
Simplifies the parser, makes it easier to extend the language. T-SQL's getting to the point where it's hard for the...
November 19, 2014 at 12:20 pm
The SQL is being called twice from the application.
An RPC is a remote procedure call, the application calling a procedure on the SQL server. One call from the app, one...
November 19, 2014 at 12:18 pm
Don't have time to hunt on google for you right now, have a quick search yourself please, you should find a pile of good material.
November 19, 2014 at 6:58 am
The error means you were trying to restore over an existing database and there was at least one connection. Double-check the name of the database you're restoring as, make sure...
November 19, 2014 at 6:50 am
The log file size is not supposed to decrease. That would be incredibly inefficient if SQL had to keep growing and shrinking the file.
November 19, 2014 at 6:47 am
First thing, a million rows isn't free to return. That will take time in and of itself, after the query has run.
November 19, 2014 at 5:29 am
SQL Galaxy (11/19/2014)
generally it will be free up space from HDD Once complete the all transactions by automatically.
No.
It would be inefficient if it did, as the database would be...
November 19, 2014 at 5:28 am
750 MB is the initial size, the size that it will be after restart. If that's not enough for your workload, TempDB will grow. In your case it's grown to...
November 19, 2014 at 4:49 am
lol2k12 (11/13/2014)
Steve Jones - SSC Editor (11/11/2014)
If you need...
November 19, 2014 at 4:45 am
Viewing 15 posts - 7,246 through 7,260 (of 49,571 total)