T-SQL

Solution Search:
model of the ShrinkDB database is set to FULL.

So the following query (fileid = 2 → the T-Log file):

select size from sysfiles where fileid = 2

Returns: 256.
This is the size of the... More...

Jun 25, 2009
the SPARSE keyword in the column definition. For instance, in the following T-SQL script, I created the Products table in the AdventureWorks 2008 sample database... More...
Jun 2, 2009
is more important than what is actually used at the time).

Transaction Diagnostic T-SQL Code - Transactions does not have to be active, just open.

The T-SQL code below should be... More...

May 27, 2009
which you can do in SQL Server Management Studio. To set the level, run the following T-SQL statements:

EXEC sp_configure filestream_access_level, 2
GO
RECONFIGURE
GO

In this... More...

May 25, 2009
have its own file rather than be stored in the same file as the table. You have to use the T-SQL editor to modify database objects because there is still no user interface (UI... More...
Apr 27, 2009
options and then permit the ad hoc distributed queries, as shown in the following T-SQL script:

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp... More...

Apr 16, 2009
no changes to your applications or databases to function, also allows you to run a T-SQL query against multiple servers from a centralized management server. This is (sort... More...
Apr 9, 2009
sys.dm_db_file_space_usage

Once you have determined the SPID, you can determine what T-SQL is running with dbcc inputbuffer(SPID).

Let's presume you know the T-SQL code that ran... More...
Mar 16, 2009
HumanResources.vEmployee WHERE EmployeeID > 1" queryout
C:\Data\Employees.csv -c -T -t,

The command retrieves data from the vEmployee view in the AdventureWorks... More...

Mar 11, 2009

If you manage multiple servers, Server Group management enables you to run T-SQL queries against multiple servers simultaneously from a central management... More...

Mar 4, 2009
example:

bcp AdventureWorks.Sales.vSalesPerson out C:\Data\SalesPerson.csv -c -T -t,

In this case, a comma is specified after the -t switch, which means that the data fields... More...

Feb 18, 2009
of flexibility, because you can control the entire process from each end within your T-SQL stored procedure.

The first step of the process is to create a table with a single... More...

Feb 16, 2009
to be made to the target. You can then save the change script to a file, open the script in T-SQL editor or -- if you're brave enough -- write schema changes directly to the target.

You can... More...

Feb 11, 2009
the correct permissions to access the full-text files stored on the hard drive The T-SQL code must also interface with another process or service outside the one on which... More...
Feb 4, 2009
safety" to drop or alter tables!' ROLLBACK ;

A DDL trigger can record the specific T-SQL logic used by running the EventData function. The EventData function basically... More...

Jan 28, 2009
data-profiling options. You could also, however, hand-code your own data profiler in T-SQL and .NET. In fact, resourceful database administrators have created their own... More...
Jan 26, 2009
this year.

#1 - SQL Server data conversions from date/time values to character types
T-SQL supports two built-in methods for converting date/time data to character data and... More...

Jan 7, 2009
tasks. This piece is a follow-up to SQL Server Management Studio: New features, part 1.

T-SQL Debugger
If you have done some programming, you know how important it is to have a... More...

Jan 5, 2009
platforms.

#1 -SQL Server data conversions from date/time values to character types
T-SQL supports two built-in methods for converting date/time data to character data and... More...

Dec 16, 2008
extending locks, their inability to cache execution plans and CPU/RAM overhead. Many T-SQL programmers and DBAs do not know how to successfully loop over records without the... More...
Nov 17, 2008

  Temporary tables in SQL Server vs. table variables

Once you've written your T-SQL code, it's time to execute it. If you are going to use a table to store data temporarily... More...

Nov 6, 2008
this series on SQL Server datetime values outlines four new data types supported by T-SQL in SQL Server 2005. SQL Server expert Robert Sheldon walks you through how to use... More...
Oct 21, 2008
Operators

Scalar operators are used for operations with scalar values. Transact-SQL supports numeric and Boolean operators as well as concatenation.

There are unary... More...

Oct 15, 2008
Server Clustering Solutions
IPControl - automated IP Address Management & DNS/DHCP server configuration by BT Diamond IP
and service levels by automating IPAM and DNS/DHCP server configuration. IPControl is a next-generation software system that enables service providers and...
Server Clustering Whitepapers
Save Money and Improve Agility: Virtualize with Sun SPARC Enterprise Series Servers by Sun Microsystems, Inc.
This paper focuses on business benefits achieved by consolidating and virtualizing environments with Sun SPARC Enterprise M-Series servers. The...
Transforming a Global Data Center Environment by Hewlett Packard Company and Intel
of these areas, including grid computing, server consolidation, data center consolidation, and long-range planning. Their use of virtualization and grid computing...
Virtualization with HP, Intel, and VMware Solution Guide for Midsize Businesses by HP, Intel, & VMware
familiar with it yet, here's a quick primer: Server virtualization is an easy and proven way to get many times the value out of your servers. It enables a single physical...
Simplifying Disaster Recovery (DR): One-Button Replication for Combined Physical/Virtual Data Centers by FalconStor Software
The FalconStor® Network Storage Server (NSS) solution can be deployed in conjunction with VMware vCenter SRM to empower VMware vCenter SRM to automate and...
IT Briefing: Making Virtual Backups Real by Data Domain
Backups Real" where Curtis Preston discusses server virtualization and backups. This document is based on a DataDomain/TechTarget webcast entitled "Making Virtual...