Moving TempDB
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
2008-08-04
6,372 reads
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
2008-08-04
6,372 reads
Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of...
2008-08-04
296 reads
I'm probably in the minority, but I use an offline reader for consuming feeds. Nothing wrong with browser based readers other than that...
2008-08-04
246 reads
We've got two technical sessions scheduled for tomorrow night. The first is by long time oPASS member Dolores Tofel discussing...
2008-08-03
318 reads
SQLSaturday #5 in Olympia is progressing nicely. 85 registered, venue locked in, and work under way for fund raising via...
2008-08-01
555 reads
Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't...
2008-07-31
1,445 reads
Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to...
2008-07-30
1,366 reads
Recently I was driving home and as I made that turn into the sub-division where I live, over the course...
2008-07-30
1,353 reads
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,154 reads
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,467 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
hi, need to known weather fast farwand cursor is faster than a while loop...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers