Sample Script Header
Sample script header to use to describe a stored procedure. This is a piece of the one I use but needs modification for each environment.
2002-04-04
781 reads
T-SQL
2002-04-01
680 reads
2002-04-01
765 reads
Find Users in a Database
This script would help you find users, their logins, roles etc in a database.
2002-04-01
333 reads
Detection of Broken Forign Key Relationship
Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]
2002-03-27
193 reads
Cast Your Data
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,782 reads
Rows count for each and every table in a DB
By using this script one can find number of rows for each and every table in a database. Just cut and past this script in your DB and excute. A stored procedure will be created as 'Get_rowcounts_for_eachtable'. If U excuted this stored procedure, U can get all tablenames and rowcounts for respected […]
2002-03-07
584 reads
List tables,stored procs & Scrips
list all user tables,stored procedures involving these tabels and the scrips of these procedures
2002-02-21
554 reads
UDF to strip brackets from phone numbers
I find phone numbers to be the messiest data that users enter. There are so many variations with brackets that I wrote this UDF to help clean up the data. Usage: SELECT Firstname , SURNAME , udfStripBracket(PHONENUMBER) AS BracketlessNumber FROM dbo.UserContact
2002-02-05
265 reads
SP to import to a file
Is a SP that imports a table to a file. You just put the table name, the path and the sa password and then you have it. It is important that it parse the table inserted (pubs.dbo.sales for example) and checks that the db, the table with the owner exists
2002-01-28
1,676 reads
Blogs
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Forums
getting logged in user name to the pc that running the report
hi all, is there anyway in SQL to getting logged in user name to...
SQL JOB add/modified
Is there a trigger to notify when a new SQL Agent job is created/modified?
View generating different plan
Hello I have a view based upon a number of tables I'm selecting...
Question of the Day
Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers