Lumigent Technologies today announced that they are a recommended supplier to provide data auditing solutions for risk management to customers of Microsoft SQL Server 2000 through their Entegra product. Enterprises that depend on SQL Server databases can now rely on Entegra as a trusted auditing solution to enable compliance with regulatory requirements.
2004-04-22
540 reads
The error handling in SQL Server leaves something to be desired, especially compared with other RDBMSes and languages. The standard method of testing for errors can leave your code bloated and hard to read. Stefan Popovski looks at another method of handling errors.
2004-04-21
8,329 reads
What's wrong with SQL Server? Lots of things to some people, but here's a look at where this product is positioned in the marketplace against the other RDBMSes.
2004-04-20
3,770 reads
A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.
2004-04-19
10,836 reads
Sometimes its good to get back to basics - or to make sure you really know all the basics. This is a very good intro to all the different join types.
2004-04-16
15,465 reads
Are you a new SQL Server administrator? A network admin or developer who got the responsibility for a SQL Server dropped on your head? Steve Jones starts a new series looking at a few of the things that you might want to know if you've never worked with SQL Server before.
2004-04-15
19,680 reads
Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.
2004-04-13
8,900 reads
According to this article Mangione will be working on security products. Paul Flessner and several other managers will take over the SQL team.
2004-04-13
69 reads
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
2004-04-12
4,410 reads
This article shows some options to retrieve all the metadata you'll need to write scripts that write scripts. No, that's not a goof, this article is about code generation.
2004-04-09
8,656 reads
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
Comments posted to this topic are about the item Creating Statistics on XML
Comments posted to this topic are about the item Managing SQL Agent in Azure...
Hi, I hope this isn't too long of a question- I tried to make...
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers