Viewing 15 posts - 76 through 90 (of 157 total)
Is SQL Server able to use indexes when using DataDiff(Day, D1, D2) = 0 ?
Best regards
Henrik Staun Poulsen
April 28, 2009 at 1:05 am
Even a blind hen can sometimes find her corn.
Thank you all for the kind words.
Best regards,
Henrik Staun Poulsen
Stovi Software
February 7, 2009 at 11:53 am
Ian,
I only wanted to see the column names that appear more than once, so that I exclude all the columns that are ok.
So I re-wrote your query to:
-- From
January 28, 2009 at 12:47 am
Hi mararity,
How do you tell the difference between mediocre and great Admin?
We have two people working with the SANs, but are they any good???
I would like to be able...
January 8, 2009 at 6:35 am
Perry,
Most people or consultants that I've spoken to has mentioned that it is important to have 64 kb sectors for SQL Server.
How is this athieved on SANs?
They also claim that...
January 8, 2009 at 2:01 am
except if you use a Table Value UDF (User Defined Function), as this example shows:
http://www.sqlservercentral.com/articles/Dynamic+SQL/65154/
Best regards,
Henrik Staun Poulsen
December 11, 2008 at 11:53 pm
Dear all,
First of all, thank you for the nice words. Writing up the article was a lot more work than I anticipated, but also a lot easier than I feared....
December 10, 2008 at 12:58 am
Hi,
Yes, that is also a solution, as pointed out on Erlands homepage (see above).
But to my management that was a more scary solution, so it was postponed.
The table-value UDF...
December 9, 2008 at 7:09 am
Hi icocks,
Well, I've seen worse; like the programmer that loved to write "BEGIN TRAN", but forgot a few "COMMIT" or "ROLLBACK".
And this system actually works, and makes money for the...
December 9, 2008 at 4:44 am
Hi Frank,
The system is quite a few years old, and there are many different .exe's running against it.
Please note that the solution supports selects, inserts, updates and deletes.
So to...
December 8, 2008 at 11:54 pm
Hi Mihit,
Thank you for a nice example on how to get yourself away from bad table design, when retaining backwards compatibility.
What you could also have shown was the use of...
November 10, 2008 at 2:13 am
We've been using this sproc for quite some time now, but we've been having the occational problem with it.
Today my coleague suggested this:
ALTER DATABASE MyDB
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
which...
July 18, 2008 at 3:42 am
Kobus,
Are you saying that running sp_updatestatistics manually "sorts things out"?
I must try that.
TIA
Henrik
July 11, 2008 at 12:14 am
Hi Kobus,
Did you see http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068
apart from the special scheduling (2:00 to 8:00) it looks as if it has more features than your procedure.
Best regards,
Henrik Staun Poulsen
July 8, 2008 at 5:01 am
Ray,
Have you seen:
http://www.sqlservercentral.com/Forums/Topic442391-146-1.aspx
?
I do not think that it is perfect, but it might help you.
HIH
Henrik Staun Poulsen
Stovi Software
April 10, 2008 at 11:53 pm
Viewing 15 posts - 76 through 90 (of 157 total)