The Software Conspiracy
This book discusses some of the issues that exist today in software. A good read for anyone developing software.
2001-07-11
2,943 reads
This book discusses some of the issues that exist today in software. A good read for anyone developing software.
2001-07-11
2,943 reads
2001-07-10
5,441 reads
2001-07-09
3,587 reads
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 reads
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,108 reads
In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.
2001-07-06
30 reads
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.
2001-07-05
3,506 reads
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.
2001-07-05
802 reads
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2001-07-04
8,839 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;