Be wary of column level encryption. It sounds like a great idea but is miserable on performance. I also know that it is very difficult and potentially impossible to create an index on an encrypted column.
2005-05-03
Your arguement is certainly valid, but there are some very good reasons to abstract your middle tier from your database. First one that jumps out is how poorly TSQL organizes logic. Since TSQL isn't an object based language, encapsulation and reuse make building a good business layer difficult. This does change with CLR in the […]
2005-05-02
I agree - I have a hard time imagining that 15 minute backups of a tlog are unusual. However there does seem to be a direct correlation between the increase in frequency and the increase in application 'hangs'. Even more to the point, the times of the application hangs often correspond with the kickoff of […]
2005-04-29
2005-04-28
Colin is attempting to provide help. Questions are not always clear as to their intent, giving more information rather than less helps other to help you. Colin is just trying to get that information to be of greater assistance. Berating him for that is pointless and ridiculous.
2005-04-28
There is no performance difference HOWEVER, there are differences for how many concurrent connections there are. PER SEAT = n Connections (basically HIGH LEVEL concept), PER PROCESSOR = n CPUs and INFINITE connections (Again HIGH LEVEL concept). The amount of connections is firmly dependent on system resources (but that is for a different topic).....The internal […]
2005-04-27
Good idea, but it should be cost effective. Micro$oft licenses is expensive, and since the DB doesn't really demand lots of processors it's no problem running 50+ databases on a dual Xeon CPU/4GB RAM. Most of if is stored procedures - so MSSQL is a must.Anybody with experience in SQL Relay?
2004-11-08
2004-11-08
8 reads
This is another way to do it assuming you have a table of ranges and descriptions of ranges.First example displays the ranges. Second example displays range names.SELECT dbo.MyRanges.LowValue, dbo.MyRanges.HighValue, COUNT(*) AS Expr1 FROM dbo.MyRanges CROSS JOIN dbo.MyData WHERE (dbo.myData.Valuefield BETWEEN dbo.MyRanges.LowValue AND dbo.MyRanges.HighValue) GROUP BY dbo.MyRanges.LowValue, dbo.MyRanges.HighValue SELECT COUNT(*) AS Expr1, dbo.MyRanges.RangeName FROM […]
2004-03-10
Congrats, Frank. And I don't think Steve, Andy, or Brian Knight are going to lock this thread just yet so you can receive the praise you so richly deserve. Age is indeed relative. One of my older math professors taught me this as he continually whipped us young whipper-snappers in class after class. Ah, the […]
2003-12-05
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers