001-A 数据库开发
关注
分享
扫一扫
武哥博文
这个作者很懒，什么都没留下…
展开
-
一个Windows界面的TableDiff表比较工具，可比较表记录差异
一个Windows界面的TableDiff表比较工具，可比较表记录差异http://download.csdn.net/source/1216181原创 2009-04-16 17:39:00 · 625 阅读 · 0 评论 -
Versatile High Performance Hierarchies in SQL Server
Versatile High Performance Hierarchies in SQL ServerPage 1 of 3 - by Dennis W. ForbesIntroductionFigure 1 : Inverted TreeFigure 2 : Corporate Reporting HierarchyEmployeeIDF转载 2009-04-16 12:47:00 · 1256 阅读 · 0 评论 -
一个SQL Server左连接的问题，和理解的不一样
回答网友提问时发现左连接的问题，不知为何以下两种写法结果不一样 USE tempdbCREATE TABLE Bus( ID INT IDENTITY PRIMARY KEY, [Name] NVARCHAR(50), [Time] DATETIME, State NVARCHAR(10))INSERT INTO BUS ( [Name], [T原创 2009-04-17 14:29:00 · 938 阅读 · 0 评论 -
Dropping multiple SQL Server objects with a single DROP statement
Dropping multiple SQL Server objects with a single DROP statementWritten By: Atif Shehzad -- 3/19/2009 -- 0 comments Stay informed - get the MSSQLTips.com newsletter and win - cl转载 2009-04-20 16:14:00 · 749 阅读 · 0 评论 -
Different ways to execute a SQL Agent job
Different ways to execute a SQL Agent jobWritten By: Divya Agrawal -- 4/15/2009 -- 0 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:33:00 · 936 阅读 · 0 评论 -
Index Fragmentation Report in SQL Server 2005 and 2008
Index Fragmentation Report in SQL Server 2005 and 2008Written By: Arshad Ali -- 3/16/2009 -- 2 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:49:00 · 819 阅读 · 0 评论 -
SQL Server 2005 Paging – The Holy Grail
SQL Server 2005 Paging – The Holy GrailBy Robert Cary, 2009/03/11 IntroductionThe paging and ranking functions introduced in 2005 are old news by now, but the typical ROW_NUMBER OVER() impl转载 2009-04-20 18:40:00 · 735 阅读 · 0 评论 -
SQL Unit Testing
SQL Unit TestingBy Alejandro Pelc, 2009/04/08 Total article views: 4276 | Views in the last 30 days: 4276 Rate this | Join the discussion | Briefcase | Print IntroductionSome ti转载 2009-04-09 11:06:00 · 1005 阅读 · 0 评论 -
Killing a SPID and Checking Rollback progress in SQL Server
Killing a SPID and Checking Rollback progress in SQL ServerWritten By: Armando Prato -- 4/9/2008 -- 0 comments Stay informed - get the MSSQLTips.com newsletter and win - click he转载 2009-04-20 15:33:00 · 962 阅读 · 0 评论 -
Date/Time Conversions Using SQL Server
Date/Time Conversions Using SQL ServerWritten By: Edgewood Solutions Engineers -- 1/3/2007 -- 3 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:24:00 · 526 阅读 · 0 评论 -
SQL Server Worst Practices
SQL Server Worst PracticesWritten By: Edgewood Solutions Engineers -- 3/13/2009 -- 1 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:44:00 · 762 阅读 · 0 评论 -
Stored Procedures: Returning Data
Stored Procedures: Returning DataBy Bill Graziano on 09 April 2001 This article discusses three common ways to return data from stored procedures: returning result sets (SELECT sta转载 2009-04-21 13:20:00 · 718 阅读 · 0 评论 -
Temporary Tables and Table Variable
Temporary TablesBy Bill Graziano Sophie writes "Can you use a Stored Procedure to open a table and copy data to a sort of virtual table (or a records set) so that you can change the v转载 2009-04-21 13:24:00 · 852 阅读 · 0 评论 -
Introduction to SQL Server 2008 Report Builder 2.0
Introduction to SQL Server 2008 Report Builder 2.0 Written By: Ray Barley -- 2/18/2009 -- 1 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:17:00 · 1543 阅读 · 0 评论 -
Using MERGE in SQL Server to insert, update and delete at the same time
Using MERGE in SQL Server to insert, update and delete at the same timeWritten By: Arshad Ali -- 3/10/2009 -- 2 comments Stay informed - get the MSSQLTips.com newsletter and w转载 2009-04-20 17:25:00 · 944 阅读 · 0 评论 -
Audit data using SQL Server 2005's COLUMNS_UPDATED function
Audit data using SQL Server 2005s COLUMNS_UPDATED functionBy Tim Chapman, TechRepublic | 2008/09/18 11:38:01Tags: function, sql server 2005 Auditing data changes in your production environmen转载 2009-04-20 19:08:00 · 728 阅读 · 0 评论 -
Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005
Using TRY/CATCH to Resolve a Deadlock in SQL Server 2005By : Brad McGeheeNov 18, 2005 A deadlock is an inevitable situation in the RDBMS architecture and very common in high-volu转载 2009-04-21 12:48:00 · 938 阅读 · 0 评论 -
Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008
Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008Written By: Michelle Gutzait -- 3/3/2009 -- 2 comments Stay informed - get转载 2009-04-20 16:19:00 · 652 阅读 · 0 评论 -
Export data from SQL Server to Excel
Export data from SQL Server to ExcelWritten By: Edgewood Solutions Engineers -- 3/16/2007 -- 10 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:21:00 · 1271 阅读 · 0 评论 -
Simple way to export SQL Server data to Text Files
Simple way to export SQL Server data to Text FilesWritten By: Ken Simmons -- 11/24/2008 -- 2 comments Stay informed - get the MSSQLTips.com newsletter and win - click here转载 2009-04-20 16:28:00 · 1476 阅读 · 0 评论 -
When was the last time your SQL Server database was restored
When was the last time your SQL Server database was restoredWritten By: Thomas LaRock -- 4/7/2009 -- 0 comments Stay informed - get the MSSQLTips.com newsletter and win - click h转载 2009-04-20 16:37:00 · 824 阅读 · 0 评论 -
Auto generate change scripts in SQL Server Management Studio (SSMS) for tables
Auto generate change scripts in SQL Server Management Studio (SSMS) for tablesWritten By: Atif Shehzad -- 4/6/2009 -- 1 comments Stay informed - get the MSSQLTips.com newsletter转载 2009-04-20 16:40:00 · 1120 阅读 · 0 评论 -
Building Integrated SQL Server Business Intelligence (BI) Solutions with Microsoft Office 2007
Building Integrated SQL Server Business Intelligence (BI) Solutions with Microsoft Office 2007Written By: Ray Barley -- 3/26/2009 -- 3 comments Stay informed - get the MSSQLTips.转载 2009-04-20 17:09:00 · 1790 阅读 · 0 评论 -
SQL中处理层级数据（Hierarchies in SQL）
Hierarchies in SQLBy GSquared, 2009/01/28 Department management hierarchies. Bills of materials. Sales regions and offices. Data access levels. All o转载 2009-04-20 18:42:00 · 1338 阅读 · 0 评论 -
SQL Server script to rebuild all indexes for all tables and all databases
SQL Server script to rebuild all indexes for all tables and all databasesWritten By: Edgewood Solutions Engineers -- 11/6/2007 -- 4 comments Stay informed - get the MSSQLTips.转载 2009-04-21 16:06:00 · 1180 阅读 · 0 评论 -
你的索引被有效的使用了吗？（Are Your Indexes Being Used Effectively?）
Are Your Indexes Being Used Effectively?By : Ashish Kumar Mehtahttp://www.sql-server-performance.com/articles/per/Are_Your_Indexes_Being_Used_Effectively_p1.aspxNov 03, 2008转载 2009-04-21 16:55:00 · 1160 阅读 · 0 评论 -
一个在线格式化sql语句的网站
http://www.dpriver.com/pp/sqlformat.htm原创 2009-04-24 16:41:00 · 1277 阅读 · 0 评论 -
避免死循环――第一部分
避免死循环――第一部分 Alexander Kuznetsov原文：http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/20/avoiding-infinite-loops-part-one.aspx 尽管有很多关于使用游标（cursor）还是循环来获取最好性能的讨论，不过有一点是毫无翻译 2009-04-24 12:51:00 · 1479 阅读 · 0 评论 -
逐行处理数据时避免死循环－－避免死循环2
逐行处理数据时避免死循环Alexander Kuznetsovhttp://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/23/when-you-process-your-rows-one-by-one-avoid-infinite-loops.aspx 当在一个循环体内逐行处理数据时，你必须确保该循环不会无休止的执行下翻译 2009-04-29 13:55:00 · 1513 阅读 · 0 评论 -
green SQL 一个开源的数据库防火墙，可用于保护数据库不被SQL注入攻击
http://www.greensql.net/ GreenSQL is an Open Source database firewall used to protect databases from SQL injection attacks. GreenSQL works as a proxy and has built in support for MySQL. The logic原创 2009-05-05 13:01:00 · 1454 阅读 · 0 评论 -
在T-SQL中正确使用字符常量以取得最佳性能
先看例子：use tempdb; -- Numbers 方便插入数据 CREATE TABLE dbo.Numbers(原创 2009-07-17 17:00:00 · 1471 阅读 · 1 评论 -
MySQL常用维护管理工具
MySQL常用维护管理工具http://xianguo.com/item/526202631 来自 月光博客 webmaster@williamlong.dot.info (williamlong)发表 收录于2009-03-05 52分享 MySQL是一个非常流行的小型关系型数据库管理系统，200转载 2009-05-06 13:21:00 · 755 阅读 · 0 评论 -
针对SQL Server约束增强的两点建议
Two suggestions to enhance constraints in SQL Server Alexander Kuznetsovhttp://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/05/04/two-suggestions-to-enhance-constraints-in-sql-server.aspx翻译 2009-05-06 15:24:00 · 1003 阅读 · 0 评论 -
使用T-SQL生成九九乘法表
-----1.使用循环-----------------------------declare @i int,@j intdeclare @MultiTable varchar(4000)select @i=9,@j=1,@MultiTable=while @i>=1begin set @j=@i while @j>=1 begin select @Mu原创 2009-05-08 12:53:00 · 3047 阅读 · 0 评论 -
SQL Server2005中查看Schema更改历史纪录
如图所示:需要SQL Server2005SP2以上版本.原创 2009-07-18 13:20:00 · 870 阅读 · 0 评论 -
VMWare可能会导致SQL Server运行不稳定
昨天QA报了一个Bug，在LabManager上安装程序后，运行时总是提示某些表不存在。检查setup程序执行的创建脚本，没有发现任何可疑的地方。该脚本运行多年，至少在数百家用户安装过。后来在网上查找资料，说VMWare可能会导致SQL Server运行不稳定。希望这是真正的原因。尽管如此，我还是把原创建语句中采用SP_Tables和@@RowCount判断表是否存在的语句改成了if not ex原创 2009-05-08 19:20:00 · 1196 阅读 · 0 评论 -
索引键的最大大小
来自： http://msdn.microsoft.com/zh-cn/library/ms191241(SQL.90).aspx 索引键的最大大小在设计包含许多键列或大型列的索引时，计算索引键的大小以确保不超过最大索引键的大小。SQL Server 2005 为所有索引键列的最大总大小保留 900 字节。这排除了在非聚集索引的定义中包括的非键列。 计算索引键的大小转载 2009-05-11 11:08:00 · 3875 阅读 · 0 评论 -
无法找到SQLFile.SQL导致在SQL Server Studio中无法创建新的查询问题的解决办法
无法找到SQLFile.SQL导致在SQL Server Studio中无法创建新的查询。 使用垃圾文件清理工具“电脑垃圾清理专家”，清理了C：盘后，发现无法在SQL Server Studio中无法创建新的查询。提示信息如下图： 经过对比其它机器发现，“C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Co原创 2009-05-12 14:49:00 · 1596 阅读 · 0 评论 -
Multiple filegroups: yay or nay?
Multiple filegroups: yay or nay?comes from: http://sqlserverpedia.com/blog/category/database-design/ Monday, September 29th, 2008Stephanie wrote in with two questions:Is there a gain in转载 2009-05-19 13:36:00 · 819 阅读 · 0 评论 -
SQL Server Profiler 模板说明
SQL Server Profiler 模板http://msdn.microsoft.com/zh-cn/library/ms190176.aspx 可以使用 SQL Server Profiler来创建模板，定义要包含在跟踪中的事件类和数据列。定义并保存模板后，可以运行跟踪来记录每个选定事件类的数据。您可以将一个模板用于多个跟踪；模板本身并不会执行。SQL Se转载 2009-05-15 13:03:00 · 1714 阅读 · 0 评论