Problem solve

SQL Transact SQL T SQL

• Applying algebraic and numeric functions in SQL Server 2008

  Expand even more on T-SQL mathematical functions with this breakdown of algebraic and numeric functions, including details on how they can be used to retrieve data. Continue Reading

• Getting ‘trigonometric’ with T-SQL mathematical functions

  Mathematical functions in SQL Server 2008 can connect admins to system information that they may not know exists. Learn to apply these functions in this in-depth breakdown. Continue Reading

• The nuts and bolts of T-SQL aggregate functions in SQL Server 2008

  Understanding how to work with aggregate functions can open new doors to the types of information retrieved from your database -- and it may not be as tricky as you think. Continue Reading

• Seizing stats and grouped data with T-SQL aggregate functions

  The power of aggregate functions goes well beyond the basics. This tip demonstrates how to work with grouped data, verify checksums, and retrieve detailed statistics. Continue Reading

• Using T-SQL string functions to convert and report on data

  There’s plenty more to learn about string functions beyond the basics. Here you’ll find details on more advanced practices, like performing a SOUNDEX analysis. Continue Reading

• T-SQL string functions: The ins and outs for SQL Server

  String functions offer flexibility to your T-SQL statements – once you understand how they work. As you might expect, the best place to start is with the functions themselves.Continue Reading

• Loading data into a Master Data Services repository

  Configuration is an important first step for setting up Master Data Services. But what about loading the data? Here is the step-by-step process for R2.Continue Reading

• Native string manipulation functions for SQL Server

  Check out this list of custom functions for basic string manipulation – a great skill for any database professional.Continue Reading

• Combining result sets from multiple SQL Server queries

  More than one operator can be used to bring multiple queries together for a single result set, but be aware that each one will provide a different result.Continue Reading

• Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

  Both statements can be used to delete SQL Server data, but some situations call for one over the other.Continue Reading

• SQL language crash course (just enough to be dangerous)

  You can't get far in the SQL Server world if you don't speak the language. Check out the basics of SQL language with examples of common SQL Server queries.Continue Reading

• Working with IntelliSense in SQL Server 2008 Management Studio

  IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can simplify coding in a big way.Continue Reading

• Determining the source of full transaction logs in SQL Server

  Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.Continue Reading

• Using the OPENROWSET function in SQL Server

  Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.Continue Reading

• Loading data files with SQL Server's BULK INSERT statement

  The BULK INSERT statement enables the bulk-loading of data files into SQL Server databases. Get instructions on how to use it, along with details on the FIELDTERMINATOR and CHECK_CONSTRAINTS options.Continue Reading