Remove comments from the SQL Code
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,628 reads
Takes text (varchar(max)) as input and strips out any comments and RETURN the string. Comment is replaced by new-line character.
2012-07-04 (first published: 2009-03-25)
2,628 reads
2012-07-03 (first published: 2012-06-21)
1,397 reads
This scripts allows to store all tables names in all databases for the current server, it stores also the creation date, this script can be runned ins SQL Server 2000 or later
2012-07-02 (first published: 2012-06-25)
1,544 reads
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,524 reads
Delete Log-shipping Tlog backup files which are already restored onto Secondary Server.
2012-06-28 (first published: 2012-06-06)
730 reads
2012-06-26 (first published: 2012-06-07)
1,495 reads
This script will search the entire server and give the name and schema of the database where the table exists.
2012-06-25 (first published: 2012-06-09)
1,507 reads
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
2012-06-22 (first published: 2012-06-09)
2,022 reads
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,274 reads
2012-06-20 (first published: 2012-05-30)
8,809 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers