SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
2011-07-25
274 reads
Site Owners
Database Size Survey
Help us collect some data on the sizes and counts of databases in your environment. Take a few minutes and answer this survey.
2011-07-18 (first published: 2011-07-01)
3,213 reads
2011-06-25
3,216 reads
2011-05-30
1,196 reads
Cartoonists Wanted
An open call to the amatuers that might want to pen some database related cartoons for Simple Talk Publishing.
2011-05-27
1,789 reads
Stairway to SQL Server Reporting Services
A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.
2011-02-09
3,910 reads
Stairway to Database Design
A series by Joe Celko that examines the craft of designing a database to meet your needs.
2010-12-06
12,876 reads
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,145 reads
2009-11-04 (first published: 2009-10-16)
161 reads
The 2009 SQLServerCentral party at the PASS Summit
Get some details about the 2009 SQLServerCentral party at the PASS Summit in November.
2009-10-29 (first published: 2009-07-20)
2,173 reads
Blogs
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
Forums
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Duplicate Documents
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers