Search Table And Field In All Database And Return Field Value
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
202 reads
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
202 reads
Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard
2013-11-14 (first published: 2013-10-31)
1,243 reads
This script displays all data files within a SQL Server database with the following relevant properties: FileName, FileLocation, FileSizeMB, SpaceUsedMB, AvailableSpaceMB, %FreeSpace, FileGrowthMB and FileGroupName
2013-11-11 (first published: 2013-10-29)
1,570 reads
I'm no big fan of dynamic SQL or cursors, however there are times where they do the job.
2013-11-08 (first published: 2013-10-29)
1,864 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
2,124 reads
A set of queries which attempt to gather as much security-related information on a server instance as possible.
2013-11-05 (first published: 2013-10-24)
3,233 reads
This query gives you an idea of the growth of your database over time.
2013-11-01 (first published: 2008-03-10)
14,438 reads
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,609 reads
This script pivots 1 to N numeric columns, grouping by 1 to N (N)(Var)char columns, pivoting by distinct date.
2013-10-30 (first published: 2013-10-15)
1,137 reads
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,896 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