Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,498 reads
Blog Posts
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,042 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,633 reads
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
918 reads
How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
823 reads
July Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,035 reads
PASS SQL Rally 2011 Evaluations
In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals...
2011-07-05
928 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,374 reads
SQL Server on steroids with RAM disk
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,572 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,005 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers