Viewing 15 posts - 29,791 through 29,805 (of 49,552 total)
Indexes are created on tables or views, not on other indexes.
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 21, 2010 at 1:15 pm
Anyone need a good laugh?
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
A: Stored procedures provide performance benefits through local storage, precompiling the code, and caching......
Database backup methods:
Full Backups
Differential...
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 21, 2010 at 1:09 pm
winash (10/21/2010)
Googled this out of curiosity and found the most disturbing explanation for index segmentation...http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
:ermm: :alien: :w00t: - looks like a "WTF!!??!!" icon is needed
Ooh. I needed a good laugh...
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 21, 2010 at 12:59 pm
subbkarth (10/21/2010)
How to take the backup of 2TB, database data using third party tool?
Depends on which 3rd party tool you're talking about. They're all pretty easy to use and all...
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 21, 2010 at 12:17 pm
No quotes for datepart.
eg
SELECT convert(varchar(2),DATEPART(hh,getdate())) + convert(varchar(2),DATEPART(mi,getdate()))
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 21, 2010 at 10:04 am
The process of removing fragmentation from an index so that, in theory, scans of the index perform better.
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 21, 2010 at 7:11 am
Improving the performance of queries/applications.
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 21, 2010 at 7:10 am
No such thing in SQL. Do you mean partitioning?
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 21, 2010 at 7:10 am
Perry Whittle (10/21/2010)
bh 58161 (10/21/2010)
I know restoring it isn't how mirroring works.Actually that's exactly how mirroring a database starts!
If he just restores the database (typical options), the 'mirror' will...
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 21, 2010 at 7:00 am
Same as any other database
A little over 500 000 TB.
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 21, 2010 at 5:35 am
bh 58161 (10/21/2010)
I know restoring it isn't how mirroring works. I meant to restore it so all have the same instance then configure the mirroring within the management studio.
Um, no,...
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 21, 2010 at 5:34 am
I seriously hope you're backing up more often than 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 21, 2010 at 5:08 am
bh 58161 (10/21/2010)
Sorry about this! Never done anything like this before. The notes on MS are not that easy to read.
See my previous comments about the editions. Is pointless going...
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 21, 2010 at 5:04 am
GilaMonster (10/21/2010)
Have you looked at the entry for SET TRANSACTION ISOLATION LEVEL in SQL Books Online?
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 21, 2010 at 5:03 am
Or maybe not...
I just noticed that you have workgroup edition of SQL. Workgroup cannot be mirrored at all. It also can't be clustered.
If you want failover, you're going to 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
October 21, 2010 at 4:42 am
Viewing 15 posts - 29,791 through 29,805 (of 49,552 total)