sql server
1 FaverShareViewed: 10 TimesQuoted: SQL Server XML View Mapper 1.0 Brief Description Microsoft® SQL Server View Mapper enables you to produce an XML View schema file that relates an ...
looks useful for a DBA
1 FaverShareViewed: 72 TimesQuoted: Use this SQL Server SP to generate a report of all SQL Server jobs.
good explanation of @@IDENTITY vs SCOPE_IDENTITY()... I never knew the difference. Also, there are 9 other things you should watch out for. (lots of common sense)
2 FaversShareViewed: 5 TimesQuoted: Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value (primary key) that was entered by your active session, but in different scenarios they can each ...
1 FaverShareViewed: 42 TimesQuoted: To generate INSERT statements from existing data. These INSERTS can be executed to regenerate the data at some other location. This procedure is also useful ...
The SQL Server 2005 Black Book features complete coverage of SQL server tools. Packed with examples and troubleshooting solutions, this book is a complete desk reference for utilizing the power and flexibility of SQL Server 2005. The Immediate Solutions provide hands-on real-world techniques to solve key problems that SQL developers face.
The book covers the full spectrum of SQL Sever 2005, from syntax to Common Language Runtime (CLR), Management Studio to Business Intelligence Development Studio (BIDS), to data warehouse and reporting services. Special chapters are provided on server maintenance, integrating .NET with SQL Server, performance, tuning, and optimization, error handling, and using SQL with XML. Free Ebook
2 FaversShareViewed: 315 Times1 FaverShareViewed: 19 TimesQuoted: Use Ajax to retrieve data from a SQL Server database and then update that database using Ajax
I wonder if there is a MySQL equivalent.
1 FaverShareViewed: 14 TimesQuoted: DBCC INDEXDEFRAG can defragment clustered and nonclustered indexes on tables and views. DBCC INDEXDEFRAG defragments the leaf level of an index so that the physical order of the pages matches the left-to-right logical order of the leaf nodes, thus improving index-scanning performance.
Related Content from Around Faves
mysql
-
There are some helpful tips in here, whether or not you use replication. In my experience, the most important thing with database performance is to minimize the time and row range over which you hold write locks -- and that's what this post is essentially about.
1 FaverViewed: 6 TimesQuoted: Piping data through application is the best solution in many cases and is quite easy - it is trivial to write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality.
- mike - May 15 20092 FaversViewed: 2 Times
- guido - Feb 22 20094 FaversViewed: 8 Times
microsoft
-
Latest blog post...
1 FaverViewed: 2 TimesQuoted: I, along with Tushar Shanbhag, recently gave a talk at PDC09 on using PHP, memcached, and MySQL to build applications with Windows Azure. We used these technologies to reinforce some key Windows Azure principles, specifically how it is easy to:
- diretiva - May 15 20093 FaversViewed: 16 Times
- derek - Sep 23 20091 FaverViewed: 4 Times
