Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
2009-07-23
1,808 reads
During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
2009-07-23
4,028 reads
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
461 reads
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
523 reads
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
425 reads
This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.
2009-07-22
6,771 reads
August 2009
Business Intelligence: Planning Your First Microsoft BI Solution
Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner
Business Intelligence: Building a Data Foundation for a BI Solution
See how you can design and build a data mart that uses SQL Server 2008 Integration Services to perform the extract, transform and load (ETL) processes for the Adventure Works BI solution introduced in "Planning Your First Microsoft BI Solution." Derek Comingore
2009-07-22
2,055 reads
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
689 reads
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
449 reads
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
441 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers