Viewing 15 posts - 7,246 through 7,260 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2014 at 12:26 pm
Yup, something is dropping and recreating the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2014 at 5:28 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2014 at 4:57 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2014 at 4:49 am
lol2k12 (11/13/2014)
Steve Jones - SSC Editor (11/11/2014)
If you need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2014 at 4:45 am
Viewing 15 posts - 7,246 through 7,260 (of 49,552 total)