Viewing 15 posts - 27,451 through 27,465 (of 49,552 total)
Nothing specific. You could replace all the 1s with 'a' and the 0s with 'b' and get the same result. It's just a trick for evaluations case conditions.
What he's doing...
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
March 10, 2011 at 2:21 am
Which DBCC? There are over 20 such commands.
Yes, it is usually necessary to rebuild indexes from time to time and do other database maintenance.
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
March 10, 2011 at 1:44 am
rithython (3/9/2011)
Thank you for your help. But, I got only the backup file in the old date before the TRUNCATE transaction. So, what should I do?
REstore it as a new...
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
March 10, 2011 at 12:59 am
jolan.mahinay (3/9/2011)
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
March 10, 2011 at 12:58 am
No performance impact. When you call it SQL simply de-obfuscates the procedure and runs it.
Be aware this is not encryption, it's just obfuscation and is trivial to reverse.
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
March 9, 2011 at 11:27 pm
Rajat Jaiswal-337252 (3/9/2011)
But the problem is this is my client requirement so i have to try up to max level i can.
Then you need to explain to the client 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
March 9, 2011 at 11:25 pm
Sysindexes and sysobjects are deprecated and should not be used any longer. The replacement is sys.objects and sys.indexes. For row counts, see sys.partitions
That said, it (as well as sysindexes) is...
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
March 9, 2011 at 11:03 pm
No. Not unless you consistently have stale stats on the prod database. If you do, that's a far bigger problem than for refresh.
To clarify, there is no requirement to update...
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
March 9, 2011 at 11:01 pm
crainlee2 (3/9/2011)
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
March 9, 2011 at 10:56 pm
There's SAN replication, but that requires 2 SANs, typically mid-upper range.
Why are you asking?
p.s. Please don't post in all caps. It's the online equivalent of shouting at people
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
March 9, 2011 at 10:53 pm
adam spencer (3/9/2011)
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
March 9, 2011 at 10:51 pm
Gagne (3/9/2011)
Gail let me put things differently then. Should I be worried about this ?
Other than as a lesson in performance tuning, no
What really bothers me is how...
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
March 9, 2011 at 12:31 pm
Brandie Tarvin (3/9/2011)
It sounds like you're restoring from a compressed backup file.
Not necessarily (if so, that's very poor compression). Backups don't include free space in the data file, so...
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
March 9, 2011 at 12:27 pm
It depends.
Seriously, size, IO throughput, other load, etc, etc
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
March 9, 2011 at 12:14 pm
Way, way too much for a table variable. It's not just the row counts, it's also the row counts in the other tables, distribution of data in the other tables....
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
March 9, 2011 at 12:13 pm
Viewing 15 posts - 27,451 through 27,465 (of 49,552 total)