Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Hidden RBAR: Triangular Joins
Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
Adobe AIR: Running SQL Commands Against a Local Database
Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers