Kimberly L. Tripp

Latest from Kimberly L. Tripp

ITPro Today logo
Innovations of the 2010s (SQL Server 2012 – 2019)
What about moving LOB data while keeping the table online?What about moving LOB data while keeping the table online?
byKimberly L. Tripp
Apr 3, 2012
3 Min Read
illustration of data cube with red arrows indicating movement
Ops and More
What about moving LOB data?What about moving LOB data?
byKimberly L. Tripp
Mar 21, 2012
5 Min Read

All from Kimberly L. Tripp

table data on white piece of paper
SQL Server
How about Filtered Indexes instead of Partitioning?
How about Filtered Indexes instead of Partitioning?
Feb 27, 2012
|
5 Min Read
byKimberly L. Tripp
computer keyboard Power Shift key
SQL Server
Did SQL Server eliminate any partitions?
Did SQL Server eliminate any partitions?
Feb 23, 2012
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Solutions to VLT concerns around statistics and maintenance!
Solutions to VLT concerns around statistics and maintenance!
Feb 9, 2012
|
4 Min Read
byKimberly L. Tripp
illustration of data with colorful numbers in background
SQL Server
Partitioned Tables v. Partitioned Views–Why are they even still around?
Partitioned Tables v. Partitioned Views–Why are they even still around?
Feb 3, 2012
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
What's a good use for a UNIQUE filtered index?
What's a good use for a UNIQUE filtered index?
Nov 18, 2011
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
How many steps should the histogram have?
How many steps should the histogram have?
Nov 11, 2011
|
5 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Why can't SQL Server update statistics on the fly?
Why can't SQL Server update statistics on the fly?
Nov 6, 2011
|
8 Min Read
byKimberly L. Tripp
ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Viewing the Last Updated Date for Statistics
Viewing the Last Updated Date for Statistics
Oct 13, 2011
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
STATISTICS_NORECOMPUTE – When would anyone want to use it?
STATISTICS_NORECOMPUTE – When would anyone want to use it?
Oct 7, 2011
|
4 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Forced parameterization–when should I use it?
Forced parameterization–when should I use it?
May 12, 2011
|
5 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
The effect of optimize for adhoc workloads–is this right?
The effect of optimize for adhoc workloads–is this right?
Apr 20, 2011
|
3 Min Read
byKimberly L. Tripp
Boxer with red boxing gloves
SQL Server
Dynamic SQL vs. OPTION (RECOMPILE)
Dynamic SQL vs. OPTION (RECOMPILE)
Feb 21, 2011
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Problems with Local Variables
Problems with Local Variables
Feb 13, 2011
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
Cloud Computing
How Does Index Fragmentation Affect SELECT Performance?
How Does Index Fragmentation Affect SELECT Performance?
Jan 24, 2011
|
4 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Choosing Default Sizes for Your Data and Log Files
Choosing Default Sizes for Your Data and Log Files
Dec 13, 2010
|
8 Min Read
byKimberly L. Tripp
ITPro Today logo
Active Directory
Should I Optimize My SQL Server Instances for Ad Hoc Workloads?
Should I Optimize My SQL Server Instances for Ad Hoc Workloads?
Nov 26, 2010
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
IT Automation
Should I Index My Foreign Key Columns?
Should I Index My Foreign Key Columns?
Nov 7, 2010
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Why SQL Server Lets You Create Redundant Indexes
Why SQL Server Lets You Create Redundant Indexes
Oct 18, 2010
|
1 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
How Many Indexes Should I Create?
How Many Indexes Should I Create?
Oct 12, 2010
|
5 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Is the Entire Clustering Key Duplicated in the Nonclustered Indexes?
Is the Entire Clustering Key Duplicated in the Nonclustered Indexes?
Sep 8, 2010
|
2 Min Read
byKimberly L. Tripp
ITPro Today logo
Early Versions (SQL Server 2000 – 2008)
Why Doesn’t SQL Server Use the RID for Lookups from a Nonclustered Index into a Clustered Table?
Why Doesn’t SQL Server Use the RID for Lookups from a Nonclustered Index into a Clustered Table?
Aug 30, 2010
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Isn’t the Clustering Key Redundant?
Isn’t the Clustering Key Redundant?
May 26, 2010
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Where does that clustering key go?
Where does that clustering key go?
May 20, 2010
|
4 Min Read
byKimberly L. Tripp
ITPro Today logo
Cloud Computing
Changing the Definition of a Clustered Index
Changing the Definition of a Clustered Index
Apr 22, 2010
|
8 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
What Happens if I Drop a Clustered Index?
What Happens if I Drop a Clustered Index?
Apr 22, 2010
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
Cloud Computing
Determining the Position of Search Arguments Within a Join
Determining the Position of Search Arguments Within a Join
Apr 1, 2010
|
3 Min Read
byKimberly L. Tripp
ITPro Today logo
SQL Server
Comparing Execution Plans
Comparing Execution Plans
Mar 26, 2010
|
4 Min Read
byKimberly L. Tripp
Using the newsequentialid() GUID Function
Early Versions (SQL Server 2000 – 2008)
Using the newsequentialid() GUID Function
Using the newsequentialid() GUID Function
Jan 23, 2007
|
1 Min Read
byKimberly L. Tripp
Essential Aspects of Database Design
Early Versions (SQL Server 2000 – 2008)
Essential Aspects of Database Design
Essential Aspects of Database Design
Jan 23, 2007
|
10 Min Read
byKimberly L. Tripp
Database Design for Performance
Ops and More
Database Design for Performance
Database Design for Performance
Oct 25, 2006
|
19 Min Read
byKimberly L. Tripp
ITPro Today logo
Data Backup
Recovering from Isolated Corruption
Recovering from Isolated Corruption
Aug 18, 2003
|
23 Min Read
byKimberly L. Tripp
ITPro Today logo
Disaster Recovery
An Ounce of Prevention
An Ounce of Prevention
Aug 18, 2003
|
1 Min Read
byKimberly L. Tripp
ITPro Today logo
Data Privacy
The Best Place for Bulk_Logged
The Best Place for Bulk_Logged
Aug 3, 2003
|
10 Min Read
byKimberly L. Tripp

Editor's Choice

person holding a smartphone that shows a document icon and a checkmark
Regulatory Compliance
Master IT Compliance: Key Standards and Risks ExplainedMaster IT Compliance: Key Standards & Risks Explained
byBrien Posey
Jul 19, 2024
5 Min Read
Laws and regulations with padlock on cloud icons on laptop computer screen
Cloud Computing
What Is a Sovereign Cloud and Who Truly Benefits From It?What Is a Sovereign Cloud and Who Truly Benefits From It?
byChristopher Tozzi
Jul 18, 2024
6 Min Read
robot and human fingers touching
Career Management
Employees Beginning to See Benefits of AI Autonomy in the WorkplaceEmployees Beginning to See Benefits of AI Autonomy in the Workplace
byNathan Eddy
Jul 3, 2024
4 Min Read
Exclusive ITPro Resources
See all ITPro Resources

Featured How Tos

hand touches red cube via HoloLens view alongside diagram showing the app deployment workflow
Digital Transformation
How To Deploy Your App on Microsoft HoloLens 2How To Deploy Your App on Microsoft HoloLens 2
ITPro Today Data Privacy Quick Reference Guide cover image
Data Privacy
Data Privacy Quick Reference GuideData Privacy Quick Reference Guide
screenshot of unity software and a text object with the words Hello World
Digital Transformation
How To Build Apps for HoloLens 2 DevicesHow To Build Apps for Hololens 2 Devices
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up
Trending

Recent What Is

person holding a smartphone that shows a document icon and a checkmark
Regulatory Compliance
Master IT Compliance: Key Standards and Risks ExplainedMaster IT Compliance: Key Standards & Risks Explained
Laws and regulations with padlock on cloud icons on laptop computer screen
Cloud Computing
What Is a Sovereign Cloud and Who Truly Benefits From It?What Is a Sovereign Cloud and Who Truly Benefits From It?
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up