DataTypes

SQLServerCentral Article

Reverse Engineering Alias Data Types in SQL Server 2000

  • Article

In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000.

5 (1)

You rated this post out of 5. Change rating

2008-05-30 (first published: )

6,704 reads

SQLServerCentral Article

Unique Identifier: Usage and Limitations

  • Article

The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.

4 (1)

You rated this post out of 5. Change rating

2004-06-24

14,014 reads

SQLServerCentral Article

Numeric Datatype Decisions

  • Article

Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each.

You rated this post out of 5. Change rating

2004-10-29 (first published: )

13,894 reads

Blogs

Refreshed in Tuscany

By

I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t...

The Community is YOU, Not Any Organization

By

As I type this, we’re leaving behind spring, and all the amazing events that...

Polyglot Persistence

By

I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...

Read the latest Blogs

Forums

SSIS task that runs a PowerQuery

By pietlinden

is there a good tutorial on how to get SSIS to run a PowerQuery...

Sub Queries Optimization

By ralahari

(SELECT Column1 FROM Table1) as --5 Table1_1 ON table3.Column1  = Table1_1.Column1 LEFT JOIN (SELECT...

UNION ALL Optimization

By ralahari

select Colum1 , Colum2  from  table 1 Union All select Colum1 , Colum2  from ...

Visit the forum

Question of the Day

Dropping a Logon Trigger

I created this trigger for testing on SQL Server 2022:

CREATE TRIGGER checksteve
ON ALL SERVER 
FOR LOGON  
AS  
BEGIN  
IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve'
 PRINT 'Steve logged in'
END;  
GO
Now I want to drop it. What do I run?

See possible answers