240个国外SQL Server高手的博客集萃
Aaron Bertrand
Adam Machanic
All Things SQL Server
Allen Kinsel - SQL DBA
Allen White
Amit Bansal writes...
Andrew Fryer's Blog
Andrew Kelly
Andy Leonard
Anything and Everything IT
Arcane Code
Arnie Rowland: Ramblings of a Harried Technogeek
B.I. for the SQL Guy
Bart Duncan's SQL Weblog
belle's sql musings
Benchmark IT Consulting
Benjamin Wright-Jones
BI Polar
BI Thoughts and Theories
Bill Ramos on SQL Server
Bluedog67
Bob Beauchemin's Blog
Bob Duffy's Blobby Blog
Boyan Penev on Microsoft BI
Brad M McGehee
Brent Ozar - SQL Server DBA
Brian Knight
Brian Knight
Carpe Datum
Carter's Dad - Parker's Dad Too!
Chadhoc.net
Chris Randall's SQL Blog
codegumbo
Conor Cunningham's Blog
Craig Freedman's SQL Server Blog
Cristian's Blog
Dan Guzman's Blog
Dangling On The Shoulders Of Giants
Dan's Blog
Darren Gosbell [MVP] - Random Procrastination
Data Dude
Dave does Data
DavidM
DBA Field Notes
DBA Will
Dejan Sarka: Posts
Denis Gobo
Dinesh's Blog :::: Being Compiled ::::
Dirty Reads ...
Donald Farmer: Foraging in the Data Forest
DotNetKicks.com - Stories tagged with SQL
DotNetShoutout - Latest published stories in SQL
Dougbert.com
Elizabeth Vitt
Eugene Asahara
Exploring SQL...
facility9
Gemini Team Blog
Glenn Berry's SQL Server Performance
Greg A. Johnson's Blog
Greg Larsen's Blog
Have Data Will Travel
Home of the Scary DBA
I want some Moore
ILIKESQL.COM blog
In Recovery...
http://blogs.msdn.com/isaac/default.aspx
It's A Musing
Jack
Jamie's Junk
Jason Massie
Jeff's SQL Server Blog
Jessica M. Moss
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, Productivity, etc.
Joe Sack's SQL Server WebLog
Joe Webb
John Gallardo's Weblog
Jorg Klein
Josef Richberg
Journey to SQL Authority with Pinal Dave
Kalen Delaney
Keep It Simple and Fast
Kendal Van Dyke
Kevin Kline
Kimberly L. Tripp: Improving *my* SQL skills through your questions!
La bodeguita de Nacho
Latest SQL-Server-Performance.com Articl
相关文档:
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--每页显示记录条数
@currentpage int output,--第几页
@orderid nvarchar(50),--主键排序
@sort int,--排序方式,1表示升序,0表示降序排列
......
系统环境:Windows 7
软件环境:Visual C++ 2008 SP1 +SQL Server 2005
本次目的:编写一个航空管理系统
这是数据库课程设计的成果,虽然成绩不佳,但是作为我用VC++ 以来编写的最大程序还是传到网上,以供参考。用VC++ 做数据库设计并不容易,但也不是不可能。以下是我的程序界面,后面 ......
面向 OLTP 应用程序的重要 SQL Server 2005 性能问题
OLTP 工作负荷的特征是存在大量相似的小型事务。
在检查数据库设计、资源利用和系统性能的重要性时,请务必牢记这些特征。下面简述面向 OLTP
应用程序的重要性能瓶颈或缺陷。
数据
库设计问题
常用查询存在过多的表联接。在 OLTP 应用程序中过多使用联接将导 ......
先来一段代码:
WITH OrderedOrders AS
(SELECT *,
ROW_NUMBER() OVER (order by [id])as RowNumber --id是用来排序的列
from table_info ) --table_info是表名
SELECT *
from OrderedOrders
WHERE RowNumber between 50 and 60;
在windows server 2003, sql server 2005 CTP,P4 2.66GHZ,1GB 内存下测试,执行时 ......