Cast Your Data
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,853 reads
Articles
The Intel Philanthropic Peer-to-Peer Program
Similar to Seti@Home, Intel has a program set up to support research for several diseases including Anthrax and Alzheimer's. It's free, it's useful, and it might make a difference. Read the notes Andy has put together and then decide for yourself.
2002-03-15
5,879 reads
How Dynamic SQL Can Be Static SQL
This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server.
2002-03-14
11,538 reads
eLEarning with IMGUniversity - OLAP
Steve Jones completed an online eLearning course with IMG University that provided an introduction to the OLAP / Analysis services available with SQL Server 2000. This article examines some of his impressions from this vendor.
2002-03-12
3,056 reads
More than 20% Discounts for SQLServerCentral.com Members
LockwoodTech and SQLServerCentral.com have teamed up to give its members special discounts on Lockwood products. Discounts for SQLServerCentral.com members are more than 20% off. All for being a free member of SQLServerCentral.com!
2002-03-11
18 reads
Reducing Round Trips - Part 3
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
2002-03-11
8,043 reads
myLittleTools announces myLittleAdmin v1.5a
myLittleTools is proud to announce the release of myLittleAdmin for SQL Server. With version 1.5a, myLittleAdmin etablishes itself as the best web-based database administration tool for ASP developers.
2002-03-11
3,250 reads
Murphy's Laws of Computing
I found this on the Internet, but I think it's really my own personal list.
2002-03-08
2,643 reads
Middle Tier Application Data Caching with SQL Server 2000
Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.
2002-03-08
2,221 reads
Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
13,123 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers