How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,076 reads
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,076 reads
This post is about two things:
1) Your Page Verification Settings are Critical
You should confirm you are running with the correct...
2011-01-25
1,218 reads
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-25
1,467 reads
Corruption is so ugly it gets a lolworm instead of a lolcat.
Let’s make one thing clear from the start:
This Post...
2011-01-24
2,382 reads
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-21
1,878 reads
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-12
2,034 reads
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-06
2,249 reads
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,110 reads
This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...
2010-12-27
949 reads
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,130 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