7 Resources for

tsql

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Passing table valued parameters in SQL Server 2008: I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass...; Tags: Database, Procedure, Microsoft SQL Server, Data, Variable, Table, Tim Chapman; Blog posts 2007-08-27
Write custom trace files in TSQL: SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace...; Tags: Monitor, Event, Microsoft SQL Server, Trace, Microsoft SQL Server 2005, Data Column, Tim Chapman; Blog posts 2007-08-20
Defining SQL Server constraints with TSQL: Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects. All competent DBAs and developers should possess the ability to logically define constraints in the...; Tags: Microsoft SQL Server, Tim Chapman, Databases, server, SalesHistory, SQL Server Newsletter, Constraint, Column, Table, TSQL, OBJECT_ID, SaleID, SaleDate, SalePrice, Listing D, Storage, Enterprise Software, Software, Data Management, Hardware; Technical articles 2007-05-07
What version of SQL Server 2005 are you running?: I have run into the situation several times where I had to determine which version of SQL Server 2005 is running including service pack. To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement:SELECT SERVERPROPERTYproductversion, SERVERPROPERTY productlevel, SERVERPROPERTY edition; Tags: tsql, steven s. warren, Sql Server 2005, Microsoft, General; Blog posts 2007-04-05
Assess a SQL Server database developer applicant's skills with this TSQL test: If a SQL Server database developer aces the verbal portion of the interview, a TSQL test is the perfect way to ascertain the true level of their programming skills. Tim Chapman presents 10 questions that will thoroughly test an applicant's TSQL expertise. Last week, I presented a list of...; Tags: Microsoft SQL Server, Tim Chapman, Databases, server, Sale Price, applicant, database, SQL Server Newsletter, Programming, TSQL, Enterprise Software, Software, Data Management; Technical articles 2006-10-23

SQL SERVER 2005 TSQL Cursors: I am using Access against a SQL 2005 database.I have 3 Tables1 Has a list of dates2 Has a list of courses with start and end dates + attendees3 Is required to get a list of attendees on each dateFor example1 tblDates might have dates for; Tags: fetch, cursors, tsql, sql server 2005, programming, software, dayCursor, @Start, andrew@..., Cursor, Microsoft SQL Server, Microsoft SQL Server 2005, FETCH NEXT; Discussion threads 2006-11-16
SQL Server Yukon: Advantages of the new PIVOT operators: Yeah,a great leap forward!:).You must know your pivot columns ahead of time!Where as in Access they are created dynamically if desired.For a true replacement of the Access crosstab dynamic pivot functionality on sql server check out the RAC utility at www.rac4sql.net.Like Access but much more powerful with many features/options.And RAC...; Tags: CLR, Microsoft Access, Microsoft SQL Server, new PIVOT operator, PIVOT, PIVOT operator, rog11228@..., SQL Server Yukon, TSQL; Discussion threads 2004-10-14

Additional Resources

MSDN Webcast: T-SQL Enhancements in SQL Server 2005 - Level 200: By now people have heard that one can write stored procedures in C# and VB .NET for SQL Server 2005. Does that mean TSQL is dead? NO! A lot has changed in the world of TSQL for SQL Server 2005. The attendee of this webcast will learn about the new...; Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management; Webcasts
How Do I... Restore a SQL Server database to a new server?: This blog entry is also available as a TechRepublic gallery and as a TechRepublic download.As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to...; Tags: Sql Server, sql backup, restore, databases, Data Recovery, Backup; Blog posts 2007-06-20
Consider data architecture and application logic when using SQL Server: By Tim LandgraveIn any new enterprise system design using SQL Server, the architect has to make some key decisions regarding the structure of the data and the location of the application logic that will manage it. SQL Server has its own programming language (Transact-SQL or TSQL) that developers can use...; Tags: Databases, Servers, e Advantage, Using TSQL, business logic, Microsoft SQL Server, application logic, server; Technical articles 2003-06-25
What version of SQL Server 2005 are you running?: TSQL statement to verify what version and service pack of SQL Server 2005 is running.; Tags: Enterprise software, Databases, Microsoft SQL Server 2005, Microsoft SQL Server, service pack; Image galleries 2007-04-05
Configure IT Quick: Use SQL Profiler to diagnose SQL Server performance issues: Use Profiler templates, event traces, and other monitoring tools to fix problems with your SQL server.SQL Profiler can help you diagnose SQL Server performance issues quickly and easily. This graphical tool lets you monitor SQL Server events based on criteria you choose. You can use it to trace events and...; Tags: Programming languages, Databases, performance, Steven Warren MCSE, MCDBA, information technology, SQL Profiler, TSQL Statements, SQL, Microsoft SQL Server, SPID; Technical articles 2002-09-19
What version of SQL Server are you running?: I have run into the situation several times where I had to determine which version of SQL Server 2005 is running including service pack. To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),...; Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren; Blog posts 2007-09-28
Put SQL Server's EXISTS construct to good use: EXISTS is standard SQL. Why say it's "SQL Server's"?The title says it all. Why imply that EXISTS is something specific to SQL Server?I've seen EXISTS referred to as a set comparison operator; I've seen it referred to as a predicate. I'm not an SQL expert,...; Tags: Databases, Etaoin Shrdlu, Microsoft SQL Server, server; Discussion threads 2007-05-01
ISQLme (zip): ISQLME is TSQL Editor with lots of built-in templates. Designed to help you perform tasks on MS SQL Server databases faster without having to remember all the syntax. You can completely manage your MSDE and SQL Express databases with this tool. Includes lots of keyboard shortcuts to improve the user...; Tags: Borland Delphi, SQL, ISQLme, Programming Languages, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2005-10-30
What version of SQL Server are you running?: I have run into the situation several times where I had to determine which version of SQL Server 2005 is running including service pack. To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')...; Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren; Blog posts 2008-06-22
Easy code archiving in SQL Server 2005: DBA Tim Chapman extols one of the virtues of SQL Server 2005 is the ability to return the entire code of an object from a system function. He notes that this function will make it much easier to archive your procedure code. As a database administrator, I always try...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Backups, archiving, database, procedure code, backup, SQL Server Newsletter, Function, Procedure, Code, System Function, OBJECT_DEFINITION, Enterprise Software, Software, Data Management; Technical articles 2007-01-12
SwisSQL--Sybase to SQL Server (exe): SwisSQL--Sybase to SQL Server is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Enterprise ASE Transact SQL code into equivalent SQL Server Transact SQL. It automates more than 95% of the Sybase TSQL code conversion with very minimal manual intervention. SwisSQL migration tool removes the...; Tags: Microsoft SQL Server, Sybase Adaptive Server Enterprise, Server, AdventNet Inc., Sybase Inc., SwisSQL Migration Tool, Databases, Enterprise Software, Software, Data Management; Software downloads 2005-07-26
Create database maintenance plans in SQL Server 2005 using SSIS: In SQL Server 2005, database maintenance plans are almost entirely created using SQL Server 2005 Integration Services SSIS. Microsoft provides a useful wizard to guide you through the creation process, but you are not required to use the wizard. This article shows you how to create a...; Tags: Task, Database, Microsoft SQL Server, Goal, Backup, Index, Microsoft Corp., Microsoft SQL Server 2005, Maintenance Plan, User Database, SQL Server Profiler, Tim, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2007-12-03
Set-based update query: In SQL SERVER 2005 I have 2 tables as follows:table1_old{ id smallint PK status bit}table1_new{ id smallint pk status bit}table1_old's records are, in effect, a subset of table1_new's records. I want to update the status flag for each record in table1_new that's in table1_old with the status value in...; Tags: Fahim Kanji; Discussion threads 2007-11-21

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (3 results)

Discussion threads (2 results)

Technical articles (2 results)

Planning for Disaster Recovery: To prevent data loss and maintain business continuity in times of crisis, IT pros must make disaster planning a top priority. This guide will help you ...; Buy Now

Help Desk Trouble Ticket Form: The Help Desk Trouble Ticket is an important document for the technical support professional. This form contains all the essential fields for maintain ...; Buy Now