Partitioning - Part 4
Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.
2008-01-17
7,451 reads
Andy Warren
Partitioning Part 4 Posted on SSC
Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series...
2008-01-17
548 reads
Sun Acquires MySQL
Just posted on Jonathan Schartz's blog. They've definitely been playing more in the open source arena, now they've got a...
2008-01-16
636 reads
Upcoming Presentations
I'll be attending the South Florida Code Camp on Feb 2 and also SQLSaturday Tampa on Feb 16th. For both...
2008-01-16
520 reads
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
482 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
900 reads
Sometimes You Need an Analog Solution, Sorta - Earth Class Mail
Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so...
2008-01-09
496 reads
SQL Injection, Again!
Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in...
2008-01-09
626 reads
Partitioning - Part 3
Continuing on with his series on SQL Server table partitioning, Andy Warren takes a look at how partitioned views are handled when you query them.
2008-01-08
8,242 reads
Partitioning Part 3 Posted on SSC
Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in...
2008-01-08
251 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers