Viewing 15 posts - 391 through 405 (of 5,356 total)
Yes, it's an interesting link, I first noticed in a posting by Gert Drapers.
Jonathan, is there a general recommendation as what is considered "best" block size? 4k? 8k? Or something...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 6:06 am
First off, severity level 1 is not the most severe you can get. Actually it's an informational level.
For contacting MS, this might help: http://support.microsoft.com/gp/profsup
Though I think, depending on...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 2:51 am
There are also beta newsgroups where you can ask about this.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:41 am
'SELECT coid FROM Nov_BusinessProfile BProfile WHERE (BProfile.BP_BusinessNature LIKE ''%1,[ ]%'')'
Note the double quotes. You need to double quote all your LIKE criterias. This should do it assuming you're executing this...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:37 am
Post the code you use along with the error you get. This will be more descriptive than any narrative. ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:32 am
Yes, whenever you can use the INFORMATION_SCHEMA views instead of directly querying the system tables, you should do so. ![]()
And yes, SQL Server 2005...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:29 am
SQL Server will always try to return the rows in the fastest possible way. This might be the order of the clustered index (if one is present), but with a...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:22 am
Yeah, he's back again!!!

...throwing in something pseudo-thread relevant...
Have a look here for RAID5: http://www.baarf.com/
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:12 am
Money, I guess ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:04 am
I think, I've mentioned, that I don't have experience with 7.0, right? ![]()
Honestly, no clue what happened. ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:03 am
Yes, that sounds now a bit different from your original question. At least as I have understood it. Anyway, for sp_user_counter, I guess you have had a look at BOL...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 1:01 am
![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 12:54 am
Yes, it does! Thank you. ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 12:52 am
Take it easy. Did you really think he would send a book? ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 2, 2005 at 12:40 am
I hear in Germany they get more than this (I like in the UK by the way).
See my second(?!?) reply in this thread ![]()
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 29, 2005 at 7:54 am
Viewing 15 posts - 391 through 405 (of 5,356 total)