Viewing 15 posts - 331 through 345 (of 411 total)
brekher,
A cursor would certainly work, but what you may want to look at is putting it in a temp table. Then take the top one value, processing it, and...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 19, 2008 at 5:58 pm
rhat (2/19/2008)
c.) Those that can....DO. Those that can't. Manage.
Yes, it's that simple. Pointy Haired Bosses are all around and aBound in the software world.
One of these days, the ones...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 19, 2008 at 10:06 am
Awesome article, and one I concur with wholeheartedly, but there is one thing I would like to add. I have worked for a large number of managers and have...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 18, 2008 at 2:34 am
Jeff Moden (2/6/2008)
Perfect... another "convert" to denounce the evils of RBAR 😛Thanks, for the feedback, Whitt. Real glad we could collectively make such a difference for you.
RBAR is definitely...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 18, 2008 at 2:18 am
localadm (2/12/2008)
You mentioned that you split the database containing BLOB into smaller chunks. I am very interested in that topic. I have a database of 0.5TB, and...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 15, 2008 at 1:29 am
This was a well done and much appreciated column.
You are quite correct in pointing out that indexed views can add complexity in requiring things such as ANSI_Nulls, ANSI_WARNINGS,...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 12, 2008 at 2:48 pm
From a strict standpoint, there are ways around denying select rights that would not work on encryption, such as copying actual files and viewing them elsewhere. But...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 12, 2008 at 1:58 pm
Quadrilaterals always have four sides, so your table would never need more than four columns to completely describe each side, and by having some standard way of numbering them you...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 3, 2008 at 5:52 pm
I may be misunderstanding your question, and also the best way to store the information often depends on what you intend to do with it.
The obvious answer if you are...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 2, 2008 at 1:26 pm
This was an interesting and good article, but I am curious what trends you are seeing to make you say that BLOBs are becoming more common. I can certainly...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 31, 2008 at 10:42 pm
This is one of the more interesting articles on SQL I've seen so far. I am definitely interested to see the end product.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 31, 2008 at 3:54 pm
This was a great article. I moved into IT from another field of management fairly recently, and in my other field transparency meant everything within the organization. It...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 30, 2008 at 1:14 am
rick (1/25/2008)
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 29, 2008 at 11:42 am
What is the best way to learn to develop CLRs and learn first hand what they are useful for and when they are useful?
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 25, 2008 at 1:53 am
I may largely be echoing Jeff here, but why create insert statements?
Pull it in directly if you can. If you do not have a reason to use...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 12, 2008 at 4:44 pm
Viewing 15 posts - 331 through 345 (of 411 total)