2003-11-03
3,335 reads
Articles
Overview of 64bit SQL
New Author! This is a great article, seems like it covers almost every question you might have about installing and using the 64 bit version of SQL2K.
2003-10-31
9,959 reads
It Cant be Done with SQL
New Author! This is a great walkthrough that starts out with a description of the problem and goes all the way to the solution - all using TSQL.
2003-10-30
12,129 reads
How to use the new function fn_get_sql() ?
This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query
2003-10-30
56 reads
Design A Database Using an Entity-Relationship Diagram
New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.
2003-10-28
22,416 reads
Cycling Those Error Logs
Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.
2003-10-27
6,294 reads
Code Stored in Files Instead of Stored Procedures
This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)
2003-10-24
8,288 reads
Bulk Data Load Using OLEDB Template Libraries
New Author! This is a fairly article that looks at how to do bulk data loading at a very (very) low level. You'll need to be able to read code to make use of this.
2003-10-23
5,802 reads
For SQL Server, XML Is One Answer
New author! Nick discusses why 'XML is One Answer', outlining some of what he believes are key points about using XML with SQL Server. This is a follow up (and sort of counter point) to another great article we had here on the site a couple weeks ago by Don Peterson. Good stuff!
2003-10-22
5,722 reads
An Interesting Article on Unicode and Character Sets
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
2003-10-21
70 reads
Blogs
A New Word: Vicarous
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
SQL Server Cross Platform Availability Groups and Kubernetes
Say we have a database that we want to migrate a copy of into...
Using Managed Identities with Azure SQL DB
We are trying to get apps and users off of using SQL accounts to...
Forums
View works for me ...but doesn't return results for a user in SSMS but no errors
Hi I have this view to check if a job is running: SELECT...
Dark mode, other color schemes
All, if you are like me and do not care for the built-in color...
Question of the Day
Internal Checkpoints
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers