How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
The post How Do I Move SQL Database Files Around?...
2010-05-11
9 reads
How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
2010-05-11
30 reads
How Do I Move SQL Database Files Around?
Introduction
Today’s script is one that I had not planned on blogging so soon but since Paul Randal just talked about...
2010-05-11
607 reads
Catching Up
Hey there gang ! – It’s been a while since I’ve written and I apologize. It’s shameful I know. I just completed...
2010-05-10
358 reads
Time Matters: Part 1
If you’re anything like me, you value every second of your day and you constantly try to find new ways...
2010-05-10
465 reads
Finding Enterprise Only Features in Your SQL Server 2008 Database
Microsoft added a new DMV, sys.dm_db_persisted_sku_features to SQL Server 2008 that you can use to determine whether you have any...
2010-05-10
1,166 reads
New Free eBook: Defensive Database Programming with SQL Server
Simple-Talk Publishing has released a new, free 291 page eBook called Defensive Database Programming with SQL Server, by Alex Kuznetsov....
2010-05-10
1,812 reads
Upcoming May SCSUG Meeting
This coming Thursday is the SCSUG meeting. This is no normal meeting. Instead of the standard format of pizza/socialization followed...
2010-05-10
914 reads
PASS Professional Development VC Reboot!
This is just a quick post to let everyone know that this week marks the return of the PASS Professional...
2010-05-10
489 reads
SQLSaturday Summit at the PASS Summit
Now that we’ve moved SQLSaturday to PASS and we’re seeing some really nice growth in the number of events, I...
2010-05-10
503 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers