A SQL Server Hardware Nugget A Day – Day 26
For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a...
2011-04-26
1,249 reads
Glenn Berry
A SQL Server Hardware Nugget A Day – Day 25
For Day 25 of this series, I want to talk about how you go about picking a CPU for your...
2011-04-25
553 reads
A SQL Server Hardware Nugget A Day – Day 23
For Day 23 of this series, I want to talk a little about some things to consider as you make...
2011-04-24
896 reads
A SQL Server Hardware Nugget A Day – Day 24
For Day 24 of this series, I want to talk a little bit about the TPC-E OLTP benchmark.
The TPC...
2011-04-24
768 reads
A SQL Server Hardware Nugget A Day – Day 22
For Day 22 of this series, I want to talk a little about 32-bit vs. 64-bit hardware, and the related...
2011-04-23
768 reads
A SQL Server Hardware Nugget A Day – Day 21
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
923 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
786 reads
A SQL Server Hardware Nugget A Day – Day 19
For Day 19 of this series, I am going to briefly discuss hardware RAID controllers, also known as disk array...
2011-04-19
553 reads
A SQL Server Hardware Nugget A Day – Day 17
For Day 17 of this series, I am going to talk about Geekbench. Geekbench is a cross-platform, synthetic benchmark tool...
2011-04-18
628 reads
A SQL Server Hardware Nugget A Day – Day 18
For Day 18 of the series, we will talk about AMD Turbo CORE technology. AMD Turbo CORE is a technology...
2011-04-18
543 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers