Viewing 15 posts - 15,961 through 15,975 (of 49,552 total)
Inserts, updates and deletes. In this case, update means change, and the index is changed by all 3 of those.
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
October 23, 2012 at 2:31 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
October 23, 2012 at 2:27 am
Not an answer, however...
The WITH ENCRYPTION on procs and functions is not encryption. It's obfuscation at best and it is absolutely trivial to reverse. If you are relying on that...
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
October 23, 2012 at 2:24 am
Mac1986 (10/22/2012)
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
October 23, 2012 at 2:17 am
Now that's gotta be entertaining to fix. 🙂
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
October 22, 2012 at 12:09 pm
Because the free space is not at the end of the file. Nothing can move log records around within a log file, so if you have 20GB of empty space...
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
October 22, 2012 at 12:08 pm
guzman_anthony (10/22/2012)
2. Run this script possible once a week?
No. As I said earlier, that script is harmful to your database and is NOT going to reduce the size of your...
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
October 22, 2012 at 10:16 am
No, it means the size of the columns you've chosen as key columns. If it meant the size of the index (which we're trying to calculate) it would be a...
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
October 22, 2012 at 10:13 am
Get more drive space or use a backup tool that compresses backups
Shrinking a database (data files or log files) will not in any way reduce the size of your backups.
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
October 22, 2012 at 9:35 am
Stefan Krzywicki (10/22/2012)
GilaMonster (10/22/2012)
Stefan Krzywicki (10/22/2012)
GilaMonster (10/22/2012)
Melktert! Awesome (well, when made properly). Apple. Lemon meringue (lemon slightly sour, meringue sweet)I've never heard of a melktert pie...
It's not 'melktert pie', it's...
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
October 22, 2012 at 9:33 am
Stefan Krzywicki (10/22/2012)
GilaMonster (10/22/2012)
Melktert! Awesome (well, when made properly). Apple. Lemon meringue (lemon slightly sour, meringue sweet)I've never heard of a melktert pie...
It's not 'melktert pie', it's just 'melktert' (english...
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
October 22, 2012 at 9:28 am
guzman_anthony (10/22/2012)
can you check this script in replacement for the previous script.. i have read this in other forum and i guess it works for them...
BACKUP LOG DBNAME WITH...
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
October 22, 2012 at 9:24 am
Yup.
(Size of index key + size of clustered index key) * number of rows / 8196 = number of leaf level pages required. It's an under-estimate, but it'll be within...
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
October 22, 2012 at 9:22 am
And do the two files that you've listed there exist in the database this is runnign from (master if you didn't specify an DB) ? If not, you'll get exactly...
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
October 22, 2012 at 9:20 am
Please note: 8 year old thread. Chandu has not logged in in 7 years.
Please don't post the same problem in multiple places.
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
October 22, 2012 at 9:16 am
Viewing 15 posts - 15,961 through 15,975 (of 49,552 total)