RAC is a native utility for MS Sql Server 2000 designed exclusively for data
manipulation.RAC can perform complex tasks while minimizing the need for complex
sql.RAC offers many computational options and has report writer features.RAC comes with a easy to use gui for novice users.
2002-03-20
3,213 reads
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,799 reads
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,873 reads
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,495 reads
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,036 reads
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
12 reads
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,034 reads
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
I found this on the Internet, but I think it's really my own personal list.
2002-03-08
2,627 reads
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
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
hi i never used shared datasets before in ssrs. i created a dataset called...
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers