A Look at SQL Server CE
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
2001-05-30
1,721 reads
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
2001-05-30
1,721 reads
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
2001-05-29
10,265 reads
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
2001-05-29
1,816 reads
You know it is time to reassess your relationship with
your computer when....
2001-05-28
1,593 reads
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,055 reads
2001-05-25
3,985 reads
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
9,928 reads
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
2001-05-24
8,845 reads
2001-05-23
2,172 reads
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,326 reads
I recently received a complaint that Query Store for a particular database was turned...
I love QuickieStore, but I wanted some columns to be at the front end...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Hi All, I would like to know the downsides of giving permissions to run...
I have a stored procedure that pulls JSON data from a US government web...
Don't know if this is the right place for this topic. I have an...
What is wrong with this code?
DECLARE @p NVARCHAR(10) = 'year' SELECT DATEPART(@p, GETDATE())See possible answers