Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

Sql Server

1-20 of 728     Previous     Next
How to Read Environment Variables in SQL Server Using T-SQL
by Deepak Choudhari
The xp_cmdshell extended stored procedure in SQL Server enables you to read environment variables in T-SQL.
Displaying the Row Number in a SELECT Query with SQL Server 2005
by Deepak Choudhari
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
Retrieving Table Size in SQL Server
by Deepak Choudhari
Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.
Choosing a Large-Text Data Type for SQL Server Table Columns
by Deepak Choudhari
SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?
Discover Long-Running Queries
by Srinath MS
Let SQL Server tell you which queries take the longest to run.
Find All User-Defined Functions in a SQL Server Database
by Jaya Nehru
This query returns all the user-defined functions in the specified database.
Table Variables Are More Efficient than Temporary Tables In Some Cases
by Srinath MS
Using @TABLE rather than temporary tables improves performance for small tables that don't require indexes.
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
Explore the Statements and Parameters Passed to SQL Server
by Cindy Rodriguez
Find out exactly what statements and parameters are passed to SQL Server.
Execute a Block of Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Executing Marked Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Quickly Determine Which Tables Need Indexes in SQL Server
by Srinath MS
A quick way to determine which tables need indexes is to use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables."
Debugging SQL Server Stored Procedures Through Visual Studio.NET
by Srinath MS
Learn how to use Visual Studio.NET to debug SQL Server stored procedures.
Determine the Version and Build Information for Microsoft SQL Server
by Alexander Ocher
Use the query shown in this tip to determine the version and build information for Microsoft SQL Server.
Obtain Information About Table Columns in Microsoft SQL Server
by Alexander Ocher
To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view.
Testing Compatibility Between SQL Server Versions
by Srinath MS
When migrating SQL code (stored procedures, triggers, etc.) to newer versions, it's not uncommon to have to rewrite your entire back-end code. However, a simpler solution is to check the exisiting code's compatibility with the newer versions.
Returning a Random set of Records
by Parthasarathy Mandayam
Find out how to use the NEWID() function to return a random set of records.
SQL Reporting Service: Using the rc:TargetLink Parameter for Drilldown Reports
by Jayadev D
Find out how to prevent SQL Server Reporting Services drilldown actions from opening in a new window.
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server— and it does not include graphical tools.
How to Backup an SQL Server Database in a Shared Network Location
by Jaya Nehru Kumar
This workaround allows you to back up shared network locations in the SQL database.
1-20 of 728     Previous     Next
Sitemap