Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
10,381 reads
Unique Index
Difference between SQL Server Unique Indexes and Unique Constraints
Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server handles them both.
2016-07-04
4,824 reads
Getting unique or primary key columns for a given table
Following script will list out all the columns which have unique/primary key constraints for a given table.
2009-01-02 (first published: 2008-12-10)
1,255 reads
RE: Password Generator
Hi,a quick hack is:declare @pwd sysname; declare @pwd1 sysname; select @pwd1=str(rand(datename(ms,getdate()))*1000000000); select @pwd=substring(@pwd1,4,len(@pwd1)); It generates quasi random strings containing 7 numbers.Karl
2004-10-21
RE: how to use time functions in sql server?
ok try something like this: create table t(d datetime) insert into t values('2002-01-01 14:15:02') insert into t values('2002-01-01 15:15:02') select * from t where abs(datediff(mi,cast('1900-01-01 '+substring(convert(char(19),d,120),12,19) as datetime), cast('1900-01-01 '+substring(convert(char(19),getdate(),120),12,19) as datetime))) <=30 Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-06-05
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers