riverlau的专栏

http://blog.sqlauthority.com/2007/08/31/sql-server-2005-find-database-status-using-sysdatabases-or-databasepropertyex/ While writing article about database collation, I came across sys.databases

SELECT (table1.name + ' ' + table2.lastname) as ownersname table1.name and table2.lastname have different collations. There is a default collation for the server. There is a default collation

Embeded Engine base on set of dlls             -not need other installation required except framework             -not run as a service    -In-proc    What it is?             -very smallembeded

http://www.sqlservercentral.com/blogs/databaseexpertisecom/2010/05/12/database-mail-set-up-in-sql-server-2008/ Introduction This article discusses about setting up and configuring SQL Server 2

http://giladka8.blogspot.sg/2012/05/running-sql-server-agent-jobs-on-demand.html PROBLEM You configure some SQL Server Agent jobs to run schedule maintenance tasks, but there is sometimes the need

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

Figure 1: Execution Model – Running, runnableand suspended status, Runnable Queue and Wait List   Figure 2 shows how SQL Serversessions rotate between the following statuses: Running (only one s

http://searchsqlserver.techtarget.com/feature/Part-1-How-cursors-work To visualize how a cursor works, think of the apparatus used by a skyscraper window washer to travel up and down the skyscrap

http://support.microsoft.com/kb/224453 Identify blocking processes SELECT spid,blocked,waittime,waitresource from master..sysprocesses where blocked>0 Waitresource This field indicates