Viewing 15 posts - 346 through 360 (of 411 total)
Awesome article. There are not nearly enough resources focusing on code efficiency and even fewer on making code legible in my opinion, and this one was well written and...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 9, 2008 at 3:56 pm
Congratulations, Steve. It is well deserved.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
January 7, 2008 at 9:29 am
I concur with Steve's wish that they would release a version for Linux, but I don't see that happening. Until then, if you do not wish to use virtualization,...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 26, 2007 at 11:21 am
I think the biggest issue is the IT culture in general. I come from a military background, and there was tremendous emphasis on developing your subordinates for 3 reasons:
1....
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 20, 2007 at 1:00 pm
Excellent article, thank you for posting it.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 20, 2007 at 12:41 pm
Max (12/20/2007)
I apologize if it's a duplicate thread. I did a search but couldn't find the answer.
I have a typical ETL process. I'd like to have SSIS wait for my...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 20, 2007 at 9:46 am
kipp (12/19/2007)
ie.
I am trying to find all tables that have...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 19, 2007 at 10:50 am
Can you add a primary key of some sort that keeps them in the order you want, such as an identity column? That would make it easier to then...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 18, 2007 at 11:14 am
Ray M
I have a problem with this when using nvarchar, my string is more than 4000 charachters and it gives me an error. Do i need to use only nvarchar...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 18, 2007 at 9:18 am
I have absolutely no experience with agile development as such, so take my thoughts with a grain of salt.
It sounds like you should by and large be able...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 18, 2007 at 9:14 am
The article was well done, but it could use some expansion. For instance, it might be worth discussing why you would want to allow SQL Server Authentication for one...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 18, 2007 at 9:09 am
There are a lot of possibilities. The most likely one is that the report is being blocked by some other process. If this is the case, then you...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 17, 2007 at 2:33 pm
Jim Russell (12/17/2007)
My fear in using global ##temp tables was that multiple users could trip over each over. Is that unfounded?
Its not absolutely unfounded, but depending on your environment it...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 17, 2007 at 1:32 pm
This is an excellent article with the author's notes, though the line warning about only using it where a dirty read is acceptable cannot be overemphasized. I have a...
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 17, 2007 at 9:20 am
Thank you all for the advice. I'll replaced the nonclustered index with a clustered index and put the heavily queried column first.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 16, 2007 at 5:30 pm
Viewing 15 posts - 346 through 360 (of 411 total)