The SQLServerCentral.com IT Research Library
We've partnered with BitPipe and TechTarget to bring a huge collection of white papers and other valuable information to you for free!
SQL Server 2005 - Setup and Deployment
So far, in our series of articles, we have presented the most significant new and enhanced features available in Microsoft's SQL Server 2005 Beta 2, but neglected to provide you with information regarding its installation. While it is more than likely that, by now, you already have accomplished this entirely on your own, we suspect that you still should be able to benefit from a more in-depth analysis of the setup process. Explaining improvements in its design and implementation is the primary purpose of this article.
Litespeed for SQL Server
Your backups are critical for the success and stability of your business. However as backup sizes grow and servers proliferate, managing the backups and storing all this data becomes a challenge. Dale Elizabeth Corey brings us a look at Imceda's Litespeed for SQL Server, a fantastic utility for helping manage your backups.
The BestOf vol. 3 and Stumpers Vol. 2
New books from SQLServerCentral.com. The latest versions of our very popular SQL Server reference materials are now available.
How to Pass Access Data Across the Web
The solution described below should probably not be considered a "best practice" but it works. It came to life as I was pondering the following conundrum: How can I pass a little bit of data from an internal Access application behind a firewall out to a public web site in real time?
Simon Says
Most of us have probably worked with some third party tool at some point in our SQL Server career. But how many tools have been written by a rocket scientist? Steve Jones had a chance to interview Red Gate Software's Simon Galbraith about a variety of topics. An interesting look at the software world through Simon's eyes.
SQL Server 2005 Roadshows
Ongoing now, the SQL Server 2005 Roadshows in conjunction with PASS. Read Robert Pearl's notes from the show and if you are in Dallas or Houston or Europe, there is still time to attend on of these events.
Identifying Long Running SQL Server Agent Jobs
In my article last month, I wrote about different methods you could use to identify the state of a SQL Server Agent job. One of the methods I discussed was using the undocumented extended stored procedure (XP) "xp_sqlagent_enum_jobs." In this article, I will show you how to use the "xp_sqlagent_enum_jobs" XP to help identify long running jobs.
Controlling Unusually Long Running Jobs
The SQLAgent scheduler in SQL Server 2000 is an amazing tool that allows you to schedule many different kinds of jobs with a great deal of flexibility. However, it doesn't have great facilities for handling jobs that may take longer than expected. And about which you'd like to be notified. Leo Peysakhovich brings us his code and technique for detecting when a job step runs long.
SQL Server 2000 Service Pack 4
It's now available!! Find out what's in there and where you can get it.
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers