Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
User contributions
From Wiki
(Newest | Oldest) View (Newer 50) (Older 50) (20 | 50 | 100 | 250 | 500)
- 15:27, 13 July 2010 (hist) (diff) m Main Page (Reverted edits by sophiegreen (Talk); changed back to last version by SQLDenis) (top)
- 10:04, 13 July 2010 (hist) (diff) m Main Page (Reverted edits by sophiegreen (Talk); changed back to last version by Remou)
- 15:24, 11 June 2010 (hist) (diff) Cursors and How to Avoid Them (top)
- 15:21, 11 June 2010 (hist) (diff) Cursors and How to Avoid Them (→Row by row processing, the impact on performance)
- 14:07, 11 June 2010 (hist) (diff) Cursors and How to Avoid Them
- 14:05, 11 June 2010 (hist) (diff) Cursors and How to Avoid Them
- 13:51, 11 June 2010 (hist) (diff) Cursors and How to Avoid Them
- 13:50, 11 June 2010 (hist) (diff) m Cursors and How to Avoid Them
- 14:30, 5 June 2010 (hist) (diff) IntelliSense does not see new objects in SQL Server Management Studio (New page: The version of SQL Server Management Studio that ships with SQL Server2008 comes with IntelliSense enabled, I still think IntelliSense is sometimes more in my way than it is useful but I w...) (top)
- 14:28, 5 June 2010 (hist) (diff) SQL Server Programming Hacks - 100+ List (→Pitfalls)
- 16:31, 26 May 2010 (hist) (diff) List all tables and columns that you have update and select permissions for on SQL Server 2005 and higher (New page: SQL Server 2005 introduced the has_perms_by_name function. If you quickly want a list of all the column and tables in the database that you have SELECT and UPDATE permissions for then you ...) (top)
- 16:22, 26 May 2010 (hist) (diff) SQL Server Admin Hacks (→Security and Permissioning) (top)
- 11:48, 26 May 2010 (hist) (diff) m SQL Server Programming Hacks - 100+ List
- 17:33, 25 May 2010 (hist) (diff) Epoch Date (top)
- 17:32, 25 May 2010 (hist) (diff) Converting Unix time to SQL Server datetime (top)
- 17:32, 25 May 2010 (hist) (diff) Converting Unix time to SQL Server datetime (New page: Unix time, or POSIX time, is a system for describing points in time: it is the number of seconds elapsed since midnight UTC of January 1, 1970, not counting leap seconds Here is how you...)
- 17:26, 25 May 2010 (hist) (diff) SQL Server Programming Hacks - 100+ List (→Dates)
- 01:56, 14 May 2010 (hist) (diff) When did DBCC CHECKDB last run to completion? (top)
- 01:26, 14 May 2010 (hist) (diff) When did DBCC CHECKDB last run to completion?
- 01:25, 14 May 2010 (hist) (diff) When did DBCC CHECKDB last run to completion? (New page: How can you find out when DBCC CHECKDB last ran to completion? Before we answer that, first you need to know that if DBCC CHECKDB runs and it reports errors or no errors then this is consi...)
- 01:15, 14 May 2010 (hist) (diff) SQL Server Admin Hacks (→Profiling and Monitoring)
- 19:31, 10 May 2010 (hist) (diff) Store More SQL Agent Job History Than The Default (New page: By default only a 1000 rows are stored in the jobs history table, so if you have a lot of jobs running you might be missing history. I had for example jobs that ran once a minute and I had...) (top)
- 19:24, 10 May 2010 (hist) (diff) SQL Server Admin Hacks (→Maintenance and Automation)
- 19:28, 4 May 2010 (hist) (diff) How to create a local SQL Server linked server (New page: It is very easy to create a linked server, all you have to do is execute the sp_addlinkedserver stored proc, pass the servername and 'SQL Server' for the server product and your are done ...) (top)
- 19:26, 4 May 2010 (hist) (diff) SQL Server Admin Hacks (→Setup)
- 17:40, 30 April 2010 (hist) (diff) List The Source Code For All DDL Triggers In Your SQL Server Database (New page: DDL triggers are triggers that fire on a database or server level. These triggers listen for DDL statemens like CREATE TABLE, DROP TABLE, CREATE TABLE etc etc etc. Here is one example of ...) (top)
- 17:26, 30 April 2010 (hist) (diff) SQL Server Admin Hacks (→Meta Data and Object Properties)
- 17:02, 30 April 2010 (hist) (diff) How to insert a row into a table with only an identity column (New page: You have the following table <Code tsql>CREATE TABLE Sequence (ID int identity not null primary key) GO </code><br> How do you insert a row into this table, you can't pass a value and you...) (top)
- 16:58, 30 April 2010 (hist) (diff) SQL Server Programming Hacks - 100+ List (→Handy tricks)
- 17:35, 29 April 2010 (hist) (diff) How to reset an identity value after a table has been emptied (top)
- 17:34, 29 April 2010 (hist) (diff) How to reset an identity value after a table has been emptied
- 17:33, 29 April 2010 (hist) (diff) How to reset an identity value after a table has been emptied
- 17:33, 29 April 2010 (hist) (diff) How to reset an identity value after a table has been emptied (New page: If you have a table with an identity column on it and if you delete all the data the identity is not reset. There are two ways to accomplish this: 1) You truncate the table 2) if you can't...)
- 17:26, 29 April 2010 (hist) (diff) SQL Server Programming Hacks - 100+ List (→Handy tricks)
- 17:02, 29 April 2010 (hist) (diff) List The Source Code For All Functions In Your SQL Server Database (New page: If you want to list all the functions in your database and their source code and if you also want to know what type of function it is, then you can use the following query. This is only fo...) (top)
- 16:57, 29 April 2010 (hist) (diff) SQL Server Admin Hacks (→Meta Data and Object Properties)
- 16:56, 29 April 2010 (hist) (diff) SQL Server Admin Hacks (→Maintenance and Automation)
- 13:39, 28 April 2010 (hist) (diff) List The Source Code For All DML Triggers In Your SQL Server Database (top)
- 13:28, 28 April 2010 (hist) (diff) List The Source Code For All DML Triggers In Your SQL Server Database (New page: If you want to list all the DML triggers, their source code and also the table name that the trigger belongs to, then you can use the following query. This is only for SQL Server 2005 and ...)
- 13:20, 28 April 2010 (hist) (diff) SQL Server Admin Hacks (→Maintenance and Automation)
- 17:14, 27 April 2010 (hist) (diff) How to debug 64 bit SSIS packages (New page: If you have ever tried to debug a script task by setting a breakpoint and the package is on a 64 bit machine it will just ignore the breakpoint. Here is how how to enable debugging for a 6...) (top)
- 17:09, 27 April 2010 (hist) (diff) SQL Server Programming Hacks - 100+ List
- 17:04, 27 April 2010 (hist) (diff) Find All The Columns In Your SQL Server Database That Are Varchar(max) Or Nvarchar(max) (New page: To quickly find all the columns in your database that are either varchar(max) or nvarchar(max) you can use the ''information_schema.columns'' view. All you have to filter for is ''data_typ...) (top)
- 16:56, 27 April 2010 (hist) (diff) SQL Server Admin Hacks (→Meta Data and Object Properties)
- 14:20, 27 April 2010 (hist) (diff) Get a rough estimate of how many lines of code you have in your SQL Server database (New page: If you want a rough estimate of how many lines of code you have in your database for functions, triggers and stored procedures you can use the query below. <Code tsql>SELECT SUM(LinesOfCo...) (top)
- 14:13, 27 April 2010 (hist) (diff) SQL Server Admin Hacks (→Profiling and Monitoring)
- 14:13, 27 April 2010 (hist) (diff) SQL Server Admin Hacks (→Profiling and Monitoring)
- 14:06, 27 April 2010 (hist) (diff) List The Count Of All Objects In Your SQL Server Database Grouped By Type (New page: If you want to quickly see how many tables, views, stored procedures and other objects your database has, you can run the query below <Code tsql>SELECT CASE xtype WHEN 'AF' THEN 'Aggrega...) (top)
- 13:59, 27 April 2010 (hist) (diff) SQL Server Admin Hacks (→Meta Data and Object Properties)
- 23:58, 25 April 2010 (hist) (diff) Basic Query Design Patterns-Selecting Records
(Newest | Oldest) View (Newer 50) (Older 50) (20 | 50 | 100 | 250 | 500)
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.