sql - Tinyint vs Bit
For performance and reliability reasons, it is strongly recommended that you use a client-server database engine for the deployment of data driven Web applications that require high-demand access from more than approximately 10 concurrent users. Although ADO works with any OLE DB compliant data source, it has been extensively tested and is designed to work with client server databases such as SQL Server. ASP supports shared file databases (Access or FoxPro) as valid data sources. Although some ASP example code use a shared file database, it is recommended that these types of database engines be used only for development purposes or limited deployment scenarios. Accessing Data with ADO
Peter DeBetta's SQL Programming Blog : T-SQL UrlEncode I was perusing the newsgroups when I came across a request in the microsoft.public.sqlserver.clr newsgroup to see if there was a way to use System.Web.HttpUtility.UrlEncode in T-SQL.
An SQL text by Erland Sommarskog , SQL Server MVP. The curse and blessings of dynamic SQL
Execution Plan Analyzer is a feature that will cut your query troubleshooting time at least by half or more. With it you can easily see the costliest plan operators based on different properties like IO, CPU, Number of rows, Cardinality, Relatice cost, etc... Can't find a node that is on a particular index? SSMS Tools Pack Features
How to export data from SQL Server 2008.2010 in DML (SQL script)
query - How to read a Text file using T-SQL
sql server - T-SQL: Opposite to string concatenation - how to split string into multiple records
Peter DeBetta's SQL Programming Blog : T-SQL UrlDecode
INSERT (Transact-SQL) WITH <common_table_expression> Specifies the temporary named result set, also known as common table expression, defined within the scope of the INSERT statement.
SELECT @local_variable (Transact-SQL) Specifies that the specified local variable that is created by using DECLARE @ local_variable should be set to the specified expression. For assigning variables, we recommend that you use SET @ local_variable instead of SELECT @ local_variable . For more information, see SET @local_variable .
Storing Variable Values in Temporary Array or Temporary List October 27, 2012 by pinaldave
Declare a variable list in SQL Server stored procedure
Database Programming: TOP Without ORDER BY? - Ward Pond's SQL Server blog Egad, a technical post!
Slow in the Application, Fast in SSMS? An SQL text by Erland Sommarskog , SQL Server MVP. Last revision : 2013-04-12. This article is also available in Russian , translated by Dima Piliugin.
Advertisement Using Large CLR UDTs in SQL Server 2008 | Development content from SQL Server Pro
MD5 Hash SQL Server Extended Stored Procedure
May 16, 2007 by pinaldave Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction
DB2 Universal Database
sql server - 900 byte index size limit in character length
Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams SQL Server CREATE TABLE syntax diagrams
sql - Are there any disadvantages to always using nvarchar(MAX)
Maximum Capacity Specifications for SQL Server The following table specifies the maximum sizes and numbers of various objects defined in SQL Server databases or referenced in Transact-SQL statements.
Indexing for Sort Performance | Data Access content from SQL Server Pro Advertisement <div><a href="//ad.doubleclick.net/N3834/jump/sql.home/technology/database_administration;pos=180_1;ptype=article;page=/data-access/indexing-sort-performance;sz=180x150;tile=1;ord=123456789?"
Clustered Index and Non-Clustered Index in SQL Server Here we are going to discuss clustered and non-clustered indexes in SQL Server; to understand these indexes clearly we should first know what database indexes are.
Immediate deadlock notifications without changing existing code
SQL String User Function Workbench: part 2
TSQL String Array Workbench
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
SourceForge.net: SQL-Viewer - Project Web Hosting - Open Source Software
SourceForge.net: Remote MySQL Viewer - Project Web Hosting - Open Source Software
BasicQuery SourceForge Project Homepage
T-SQL Developer project home page
SourceForge.net: SQL Server Service Manager - Project Web Hosting - Open Source Software
SQL Buddy Sourceforge Site
Transact-SQL Analyzer | Free Development software downloads at SourceForge
c# - SQL: Update a row and returning a column value with 1 query
LINQ to XSD - Home
User Defined Functions in Microsoft SQL Server 2000
Export data from SQL Server to MS Access
Statistics in SQL Server
Named Pipe in ADODB Connection - Xtreme Visual Basic Talk
How to Connect to a SQL Server Named Instance
Timeout error when trying to delete records
Overview of the SQL Server Browser service
Andy Leonard : Quick Database Connectivity Testing
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server - SQL Protocols
sql server - How to get a list of users for all instance's databases
SQL Server Named Pipe Connection...
How To Set the SQL Server Network Library in an ADO Connection String
Aaron Bertrand : Bad habits to kick : choosing the wrong data type
Chastised for recommending use of bit data type
myLittleAdmin (for SQL Server and MSDE) v.2.7 r.117
CONQUEST SOFTWARE SOLUTIONS - Tools for Oracle development, database administration, SQL and PL/SQL formatting, analysis and flowcharting, oracle development tools, pl/sql gui, plsql ide, pl/sql tools, pl/sql ide, pl/sql environment, pl/sql development, p
SQL Developers - Mimer SQL-2003 Validator
Subqueries with NOT EXISTS
Meta Data Functions
sql server - How do you perform an IF...THEN in an SQL SELECT
CAST and CONVERT
sql server 2000 - SQL2000 safely cast a VARCHAR(256) to INT
int, bigint, smallint, and tinyint
decimal and numeric
float and real
ntext, text, and image