|
|
-
|
|
The FMTONLY option can be SET to ON if applications need to know the format of the response and test it without actually running the query. The query is parsed, compiled, executed and only the meta-data is returned to the client application. ADO makes use of such a mechanism as a "dry-run" before actually executing a query. The FMTONLY is recommended only for SQL 2008 R2 and below....
|
|
-
|
|
What would you do if someone tells you to parse and compile a T-SQL query without executing it? While there is no mechanism to realize this requirement through the SSMS UI, one can use the SET option - NOEXEC. This post is a quick introduction to the NOEXEC option....
|
|
-
|
|
What would you do if you wanted to check whether a particular query/batch you wrote is free from any errors without using Intelli-sense and without executing or compiling the statement? A T-SQL solution within Microsoft SQL Server to this challenge is to use the SET option PARSEONLY to ON....
|
|
-
|
|
A step-by-step guide on how you can install the help/Books-On-Line/Product documentation collections for SQL Server 2012 in two modes - offline and online for firewall and proxy restricted environments....
|
|
-
|
|
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say – “simply replace EXEC with calls to sp_executesql and the system becomes SQL injection-proof”. This has to be the biggest misconception of all times around this subject....
|
|
-
|
|
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the situation....
|
|
-
|
|
What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the SQL Server Profiler and demonstrates the necessary command to assign a login these permissions....
|
|
-
|
|
Storage, although cheap is a limited resource. When working with multiple backups, it becomes essential to backup the databases using compression. Today's post explores how backups can be made smaller by compressing them using native SQL Server functionality - either individual (i.e. with each backup) or as a SQL Server instance level setting - 'backup compression default'....
|
|
-
|
|
When documenting a database, one of the first things that is done is to document the list of tables in the database and the primary and foreign keys to establish a relationship between them. Today, I will share 7 different scripts to identify primary and 6 different scripts to identify foreign keys within a SQL Server database....
|
|
-
|
|
Open connections consume server resources. If you need to frequently disconnect all your open connections to the corresponding SQL server instances from the multiple queries open in SQL Server Managment Studio (SSMS), this neat little feature built into the SSMS can come in handy....
|
|