datetime tune date into pad dynamic cursor money percent sp job isnumeric while over update
FREE TRIAL  SQL 2012 PROGRAMMING  SEARCH
SQL Server Scripts SQL 2005 SQL 2008 Articles
SQL JOBS NEWS FORMAT DEV JOBS

SQL Server 2005 Administration Best Practices
SQL Server 2005 Advanced SQL Best Practices
SQL Server 2005 Performance Tuning and Optimization Best Practices
SQL Server 2005 Database Design Best Practices


SQL Server 2005 Best Practices

 
Most Popular How To Topics

How to format datetime & date with century?

How to prepare, test & execute dynamic SQL?

How to apply aggregates with over partition by?

How to format a money column?

How to create crosstab report using PIVOT?

How to create empty & populated tables with SELECT * INTO?

How to count quickly the rows in all tables?

How to construct nested cursors?

How to generate a sequence?

How to SELECT from a stored procedure?

How to use COLLATE database_default?

How to shrink the transaction log file?

How to UPDATE with GROUP BY?

How to pad a numeric type column with leading zeros?

How to recover a database marked suspect?

How to convert from string to date?

How to add sequential row number column to a table?

How to generate Subtotal, Total and Grand Total columns?

How to generate a sequence?

How to measure query execution time in millisecs?

How to start a SQL Server job from a stored procedure?

How to convert from string to datetime?

How to use the ISNUMERIC function?

How to cycle (reset, clear) the error log?

How to disable all triggers and constraints?

SQL ROWVERSION (timestamp) Article

SQL CROSS APPLY Article


 
SQL Server 2005 IT Career Powering Scripts

How to create an organization tree?

How to apply SQL Server 2005 CTE for Chart of Accounts?

How to build and execute dynamic SQL queries?

How to prepare monthly pivot report with CASE?

How to reindex all fragmented indexes in a database?

How to calculate employment service time and age?

How to list all primary and foreign keys in a database?

How to catch duplicate insert with TRY-CATCH?

How to use the Common Table Expression?

How to import & export image using varbinary(max)?

How to form SSIS expression for derived column transformation?

How to convert from string to datetime?

How to parse a list with delimiter such as csv?

How to architect a sublist with XML path?

How to read a notepad text file into a table?

How to apply all the RANKING functions?

How to sort employees with ROW_NUMBER for each manager?

How to find all the available collations?

How to program a quarterly sales report with CTE and PIVOT?

How to use SQL CROSS JOIN in automatic sequence generation?

How to build an SQL stored procedure with INNER JOINs?

How to use CROSS APPLY with an aggregation subquery?

How to find the maximum of two numbers?

How to find the minimum of two numbers?

How to architect running total using cursor?

How to use the CASE function in a WHERE clause?

How to form Common Table Expression (CTE)?

How to sql format datetime without century?

How to find top 10 for each group?

How to resolve string concatenation collation conflict?

How to use the XML value method?

How to architect a trigger for column update?

How to sort on multiple conditions?

How to apply SQL Server 2005 CTE for purchase order reporting?

How to swap rows to columns?

How to construct a crosstab of subcategory by color?

How to find the number of occurrences of a string?

How to architect a SQL Server 2005 stored procedure?

How to ROLLBACK a transaction?

How to apply the scope_identity function in an INSERT sproc?

How to construct multiple ranking of a data set?

How to paginate company contact information?

How to architect math drill sproc for subtraction?

How to architect math drill sproc for addition?

How to generate a date sequence with ROW_NUMBER?

How to use derived tables?

How to architect a SQL Server 2005 dynamic PIVOT?

How to filter result set by the ROW_NUMBER function?

How to build a stored procedure for wildcard search?

How to generate a date sequence?

How to apply CASE in ORDER BY for complex sorting?

How to export data directly into a flat file?

How to apply varbinary(max) in encryption?

How to resolve collation conflict in SELECT?

How to keep track of the stock market?

How to concatenate all the last names with xml path?

How to generate running totals with a simple update?

How to use COALESCE instead of ISNULL?

How to get results from a dynamic SQL query?

How to calculate Monday's dates in a month?

How to build a junction table with nested cursors?

How to convert numbers into hexadecimal?

How to generate a sequence in SQL Server 2005?

How to calculate the median?

How to apply GROUP BY with HAVING?

How to list the bottom page of a result set?

How to return the nth page of a result set?

How to summarize products transactions?

How to list product details?

How to remove multiple spaces from a string?

How to architect dynamic ORDER BY?

How to use the DATENAME function?

How to use the GROUPING function?

How to generate binary sequences?

How to find missing values in a date sequence using EXCEPT?

How to find the second highest salary?

How to calculate the present value and future value of money?

How to rank sales?

How to create a function to count characters in a string?

How to create crosstab by year using SQL Server 2005 PIVOT?

How to apply FULL JOIN in queries?

How to perform ORDER BY in a view?

How to create an employee history view?

How to use the ALL operator?

How to use TABLESAMPLE with aggregate functions?

How to combine SQL Server 2005 CTE with SQL Server 2005 PIVOT?

How to apply self-join for cross-row stats?

How to calculate average salary by department?

How to stream data into XML document?

How to find missing numbers in a sequence?

How to design tables for a CD collection?

How to use instead of triggers to comply with Sarbanes-Oxley?

How to construct correlated datetime query?

How to use nested TRY-CATCH to catch all errors?

How to apply CTE for purchase order reporting?

How to use windowing functions?

How to full-text search for a prefix?

How to update year-to-date sales figures?

How to use COALESCE and ISNULL?

How to use NULLIF function with COALESCE?

How to use XML AUTO and XML PATH?

How to setup state code abbreviations with CASE and lookup table?

How to find all sprocs where column is used?

How to benefit from sprocs versus client applications with scripts?

How to find tables without clustered index?

How to find out the available free space in database files?

How to full-text search for inflectional forms?

How to estimate index size by rule-of-thumb?

How to create a product list by category?

How to construct an executive organizational chart?

How to generate detach-attach script?

How to generate a phone directory?

How to use READTEXT for text reading?

How to find all the foreign key definitions?

How to backup all databases?

How to apply SQL Server 2005 TRY-CATCH in money transfer?

How to use the ALL operator?

How to use the CASE function to create computed column?

How to find the nth occurrence of a substring?

How to generate quintile ranking of the sales force?

How to count the days in a month excluding weekends?

How to use the CASE function to decode a Boolean column?

How to build a minmax table-valued function?

How to find the nth item of a list?

How to restore a database with SQLCMD?

How to check the status of a job?

How to construct a stored procedure in a schema?

How to grant execute permission on all sprocs?

How to generate RUNNING TOTAL with CROSS APPLY?

How to generate RUNNING TOTAL with FAST FORWARD cursor?

How to parse out filename from path with a function?

How to apply nested SQL Server 2005 CTEs?

How to hide repeating cell values in query results?

How to list the definitions of all stored procedures?

How to list all check constraints in the database?

How to parse a full name into first, middle and last names?

How to put the query results into a variable?

How to find all the components of a mountain bike recursively?

How to check fragmentation for all the indexes?

How to architect a yearly sales report?

How to look at the head of any table with SQLCMD?

How to detach 200 SQL Server 2005 databases?

How to filter non-digits with a scalar function?

How to obtain a list of startup stored procedures?

How to display graphically a disk directory tree?

How to obtain color and weight of bikes with an XQUERY?

How to SELECT with UNPIVOT from a table?

How to disable and enable an index?

How to generate a 3-dimensional BI report?

How to obtain the definition of all the functions?

How to generate date series with table-valued function?

How to apply recursive queries for organizational charts?

How to build crosstab report by vendor by month using PIVOT?

How to find the maximum length of an XML column?

How to export an entire database into an Excel spreadsheet?

How to transfer data between linked servers?

How to create a test table with billion rows?

How to generate roulette wheel random numbers?

How to generate the date for last Sunday?

How to obtain the maximum salary for each department?

How to obtain the minimum salary for each department?

How to find all tables in a database?

How to use the XMLNAMESPACES clause?

How to use SQL Server 2005 CROSS APPLY on a derived table?

How to sort results randomly?

How to apply scalar-valued function for restaurant specials?

How to tell server edition, version and service pack number?

How to truncate backup history?

How to enable the SQL Server 2005 CLR feature?

How to find all sales staff involved with touring frames?

How to calculate distribution percent on base?

How to check the YTD performance of the sales reps?

How to find shared drives with Dynamic Management View?

How to validate a date?

How to use SQL Server 2005 CROSS APPLY to increase company profits?

How to model a sales rebate incentive program?

How to list all permissions in effect?

How to import a flat file into the database?

How to form a list with XML PATH & text()?

How to delete 100 million rows from a table of 5 billion rows?

How to cleanse a string from undesired characters?

How to limit a job execution time?

How to delete in small segments?

How to link a database user to a server login?

How to find which partition a row located in?

How to disable a trigger?

How to export all the product reviews into XML?

How to use SQL INNER JOIN in complex queries?

How to find the top 5 salaried employees with a subquery?

How to create a DDL trigger to prevent table drop or alter?

How to setup a monthly crosstab report with PIVOT?

How to perform the equivalent of GROUP BY?

How to capture with OUTPUT the inserted auto identity value?

How to rank employees by age within department?

How to export purchase order data with XML AUTO?

How to retrieve photos with varbinary(max) data type?

How to join table & table-valued function with CROSS APPLY?

How to block a column update with a trigger?

How to handle Chinese, Japanese and Korean characters?

How to handle Arabic language characters?

How to monitor the disk drives for low free space?

How to create a global temporary table?

How to find out the last update for index statistics?

How to use TABLESAMPLE for statistical sampling?

How to export multiple result sets into one file?

How to change Recovery Model for backup purposes?

How to create list results using XML PATH?

How to apply the TOP clause with UPDATE?

How to prepare a crosstab report using CASE?

How to audit data changes with the OUTPUT clause?

How to create a view with a CTE?

How to find the maximum of two datetime columns?

How to do a DIR from a stored procedure?

How to combine date and time into datetime?

How to use the EXCEPT operator?

How to architect a sales crosstab by City & State?

How to update 29 million rows of SalesOrderDetail table?

How to use the INTERSECT operator?

How to list recent orders placed by stores?

How to find customers to call about missing part?

How to turn on IDENTITY on an existing column?

How to use expression with the TOP clause?

How to delete a column from a table?

How to create a covering index?

How to update with correlated subquery?

How to create a composite index?

How to force floating-point arithmetic on integer columns?

How to apply CTE for yearly product sales report?

How to find orders by sales department employees?

How to detect carriage return and line feed?

How to drop all stats on a table?

How to do inner join with a GROUP BY?

How to find the 5 largest orders for each customer?

How to turn on SHOWPLAN?

How to apply the GROUPING function?

How to find out the server name?

How to define a SYNONYM for a table?

How to architect a function for Title Case?

How to perform an update in a different database?

How to backup a terrabyte database to tape?

How to optimize a large in list?

How to calculate factorials with a recursive function?

How to delete from a table with 800 million rows?

How to SELECT TOP items with TIES?

How to return multiple rows with OUTPUT?

How to execute a cmd file?

How to build a mortgage refinance calculator?

How to obtain the last backup statistics for all databases?

How to setup a bank database for loan processing?

How to make a linked server connection to ORACLE work?

How to dedicate a server to SQL Server 2005?

How to use ALTER PROCEDURE?

How to update from a different database?

How to use the SPACE string function?

How to export table into a Notepad file?

How to update the inventory table with the EXISTS clause?

How to add a check constraint for email verification?

How to synchronize tables with correlated subquery?

How to update 5 million home equity loan accounts?

How to find the highest yield CD at your local bank?

How to sequence the output for clothing products?

How to copy 100 million financial transactions from one bank database to another?

How to count the rows in all tables?

How to find all the ball bearing locations on the factory floor?

How to locate all bicycle parts in finished goods storage?

How to find all the bosses and all the employees?

How to sequence credit cards using ROW_NUMBER?

How to get 10 random products using the NEWID function?

How to rank mountain bike parts by quantity on hand?

How to use the Hungarian notation effectively for naming?

How to handle Case Sensitive columns in Case Insensitive database?

How to handle over five thousands connections?

How to terminate orphaned connections?

How to find out the last restore date for a database?

How to find the top salaried employee for each department?

How to find out free disk space available on server drives?

How to determine the primary domain name for the server?

How to connect to SQL Server 2005 from Java Applications?

How to calculate yearly sales revenue of mountain bikes?

How to find the employee's and manager's last order date?

How to find Monday's date for any date?

How to cleanse and standard format phone numbers?

How to keyword search programming objects?

How to page in a double nested list?

How to create a FILEGROUP with multiple diskdrives?

How to perform case sensitive CASE in case insensitive database?

How to insert a photo into the photo table?

How to get frequency for a subset of first names?

How to find keywords in stored procedures?

How to use DBCC UPDATEUSAGE?

How to exclude some rows from a sum?

How to create list results using CROSS APPLY?

How to empty the transaction log file?

How to apply ISNULL with datetime column?

How to generate a Cartesian product?

How to apply select into table?

How to backup a four terrabyte database?

How to name backup file extensions?

How to create a weekly pay period calendar?

How to use sp_helptext system stored procedure?

How to obtain FAST_FORWARD cursor?

How to generate comma separated list from a SELECT?

How to find out the database filenames?

How to create a timestamp trigger?

How to schedule a job for the first four Sundays of the month?

How to delete duplicates & find duplicates in a table with two keys?

How to find names with accented letters?

How to find the top n salaries by department?

How to monitor SELECTs on a table?

How to find out the last backup dates of all databases?

How to use the AUDIT LOGIN EVENT in SQL Profiler?

How to use the INFORMATION_SCHEMA views?

How to generate a RUNNING TOTAL column?

How to search all stored procedures?

How to restore a database from a batch?

How to Use SQL Server Migration Assistant?

How to use CASE in ORDER BY?

How to find the nth highest price by color?

How to page through a SELECT result set?

How to create a counting function?

How to check if login has DB access?

How to SELECT from system tables?

How to execute a stored procedure on a remote server?

How to find the objectid of a database object?

How to enter sqlcmd in administrator mode?

How to find blocked processes?

How to construct purchase summary for all vendors?

How to work with SQL collation?

How to find all tables without primary key?

How to declare a table variable?

How to set column length in Query Editor results window?

How to rename backup file with date suffix?

How to change date and time on SQL Server 2005?

How to recover when IDENTITY insert reaches limit?

How to generate address labels?

How to create a linked server login?

How to link to an Access database?

How to export query results into a file?

How to apply the CHECKSUM function?

How to export table content into XML file?

How to start a job from a batch?

How to get a list of files in a folder?

How to increase performance by table design?

How to reduce SQL Profiler's output?

How to increase performance by indexing?

How to get the top 5% of rows?

How to ORDER BY case insensitive in a case sensitive database?

How to get the column list of a table?

How to number a textfile prior to database import?

How to create a differential backup?

How to load example reports from Reporting Services bonus CD?

How to create a flat file from a stored procedure?

How to tell when a store procedure was modified?

 
Exam Prep 70-461
Exam 70-461