What is the “cost” in Cost Threshold for Parallelism?
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
503 reads
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
503 reads
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
379 reads
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...
2017-04-11
479 reads
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,243 reads
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
485 reads
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...
2017-04-03 (first published: 2017-03-16)
1,577 reads
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
497 reads
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
714 reads
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....
2017-03-27 (first published: 2017-03-14)
1,127 reads
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
502 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers