Optimizer Timeouts with XQuery
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,098 reads
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,098 reads
A followup to a post about subqueries with an estimation for how long it would take for the query to...
2011-05-30
2,782 reads
Agile! Scrum! Development methodologies! Sprint!
If you have a manager who reads any web page about being a manager, then you...
2011-05-29
8,312 reads
Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay. Its a true pleasure to...
2011-05-29
1,330 reads
Have you made the mistake of dropping your distribution database like this?
If so, remember not to do this ever again. ...
2011-05-28
1,980 reads
ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity states the principle of All...
2011-05-28
4,136 reads
Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...
2011-05-28
11,710 reads
AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...
2011-05-28
2,863 reads
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
830 reads
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-27
829 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers