Viewing 15 posts - 16 through 30 (of 65 total)
Hi Hugo - I got all four of these (surprise, surprise)... 😎
Like any tool, you should understand what it does before you use it...
November 3, 2015 at 11:49 am
serge 65885 (11/2/2015)
November 2, 2015 at 7:04 pm
I got the three primary issues right, but missed the performance one. I would be surprised if the performance difference was as high as 1-2% and I suspect it...
November 2, 2015 at 10:28 am
I work in Public Safety (i.e., law enforcement) and we needed to be able to do support work for some large customers where the actual size of the data AND...
October 29, 2015 at 7:51 pm
Jeff Moden (10/28/2015)
October 28, 2015 at 12:05 pm
Jeff Moden (10/26/2015)
I'll just bet they didn't send you a check for finding such a problem either. 😀
True that... 🙁
October 26, 2015 at 7:09 pm
Jeff Moden (10/25/2015)
[font="Arial Black"]The reason why I'm so interested in this is because it HAS happened before.[/font] I believe it was post 2000 SP2 but SQL Server ignored a...
October 26, 2015 at 4:41 pm
SQLBill (10/26/2015)
IMO, databases/tables/columns, need to be designed based on what information you want to get out of it. Then you determine what information needs to go into it.-SQLBill
Absolutely correct!...
October 26, 2015 at 4:17 pm
Jeff Moden (10/24/2015)
October 25, 2015 at 12:58 pm
If this is a simple attribute which is rarely to be used as a key filter in queries, then I prefer the "IsActive" approach.
However, if this "IsActive" column is to...
October 24, 2015 at 6:38 pm
Eric M Russell (10/20/2015)
Why import it into SQL Server, rather than staging the records to flat files which can be archived or deleted when no longer needed?
The database tables are...
October 20, 2015 at 12:09 pm
Eric M Russell (10/19/2015)
it's indicative of poor ETL processing or poor data modeling. I mean, why insert something and then delete it?
We have interfaces with other systems where data is...
October 20, 2015 at 9:14 am
Thanks for all the replies. A couple of observations/comments.
Absolutely agree with the WAITFOR breaks. When doing a lot of transactions, I always insert these to avoid getting to...
October 19, 2015 at 11:19 am
Jeff Moden (10/17/2015)It's no wonder C-Level types think they don't need a DBA.
But doesn't Microsoft sell SQL Server against Oracle by telling everyone they don't need a DBA with SQL...
October 19, 2015 at 10:57 am
I should have been clearer - I would recommend creating BOTH indexes in either of the two sets, not just one or the other. Because the query has two...
October 9, 2015 at 1:31 pm
Viewing 15 posts - 16 through 30 (of 65 total)