Using Query Analyzer Templates
Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!
2003-04-28
10,400 reads
Articles
System RAM Comparison
Another link from Steve Jones, this page has a great breakdown of the different types of RAM.
2003-04-24
808 reads
White Paper - Select the Best Approach for Data Integration
This white paper was written by Alain Dumas, founder of Sunopis. Looks interesting. Looks like they sell a tool that does ETL, replication, data cleaning, and more. We haven't reviewed the product, just thought it was something that might be of interest to our readers
2003-04-22
1,023 reads
Getting Your Server Information
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
2003-04-21
7,102 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
2003-04-18
18,249 reads
Upcoming Event - Microsoft TechEd 2003 in Dallas
TechEd will have 350 sessions designed to suit the needs of developers, architects, IT professionals, database, network and system administrators, messaging and security specialists. Andy is going, if you're planning to attend post a comment or send him email (awarren@sqlservercentral.com)!
2003-04-17
746 reads
AWE Adventures
Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?
2003-04-16
23,912 reads
Building Communities with Software
Steve Jones found this link that has some great thoughts on how software should be used to help build a community. Read this if you have time and post some comments. One thing in particular we liked (read the article!) were the comments about emailing responses. Your comments on this one will help us plan as we continue to try to build a better site/community.
2003-04-15
792 reads
What's In A Review?
Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.
2003-04-14
3,227 reads
The SQL Server Black Box
Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.
2003-04-11
16,925 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers