Viewing 15 posts - 12,676 through 12,690 (of 49,552 total)
Modest DBA (6/19/2013)
yes, temp tables which also makes use of Unions... which is fine. (that will use up tempdb space but on the mdf only if i am right?)
No, you're...
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
June 19, 2013 at 8:14 am
Modest DBA (6/19/2013)
tempdb works a little different as opposed to normal db's, the mdf is used in processing of query's, hash tables, union joins etc.the ldf is not used.
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
June 19, 2013 at 8:12 am
aaron.reese (6/19/2013)
Any idea why the first query does not throw an error?
Because when you have a subquery the tables in both the outer query and subquery are in scope. 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
June 19, 2013 at 6:54 am
iiit.raju (6/19/2013)
I am thinking the answer is 4 but some are telling that the answer is 3.So can you plese tell me the correct answer with explanation.
Why don't you create...
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
June 19, 2013 at 6:35 am
Steve-3_5_7_9 (6/19/2013)
GilaMonster (6/18/2013)
Backup, copy, restore. Nothing different.2008 and 2008 R2 have the same compatibility level - 100.
What you want to updatestats in this case too or is it not applicable?...
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
June 19, 2013 at 6:26 am
CheckDB with repair allow data loss or restore from backup.
p.s. Emergency mode is the last resort for when you have a suspect database and no good backup. It's never 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
June 19, 2013 at 5:26 am
No, it's not showing there's data in multiple partitions.
From Books online:
$PARTITION returns the partition number for any valid value, regardless of whether the value currently exists in a partitioned 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
June 19, 2013 at 5:22 am
Mirroring yes, though it's not supported, not recommended and not very useful except as part of a rolling upgrade. But then log shipping up-version isn't all that useful either.
Replication can...
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
June 19, 2013 at 3:55 am
Partitioning is for ease of index maintenance and data loads.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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
June 19, 2013 at 3:27 am
How are you identifying that the partitions are still there?
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
June 19, 2013 at 3:25 am
Multiple choice exam mostly.
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
June 19, 2013 at 3:03 am
Rebuild it onto a filegroup, not just rebuild it.
CREATE CLUSTERED INDEX .... WITH DROP_EXISTING ON [Filegroup Name]
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
June 19, 2013 at 2:59 am
Rebuild the table (heap or clustered index) onto a filegroup.
Not a nonclustered index. Rebuilding the clustered index is done just the same way as rebuilding a nonclustered index, you just...
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
June 19, 2013 at 1:51 am
Ramana Reddy P (6/19/2013)
Can u explain how to remove partition on single table.
I did.
Rebuild the table (heap or clustered index) onto a filegroup.
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
June 19, 2013 at 1:02 am
No idea. Not enough information.
Please post query, table definition and index definitions,
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
June 19, 2013 at 12:59 am
Viewing 15 posts - 12,676 through 12,690 (of 49,552 total)