Forum Replies Created
Viewing 15 posts - 4,816 through 4,830 (of 5,356 total)
-
RE: SSWUG and PASS
Hi,
thanks to replies, though they didn't make a decision easier
I had my subscription to SQL Server mag, before I was aware of SSWUG.
BTW, is there...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SSWUG and PASS
quote:
The PASS conference is very worthwhile. Not as sold on the value of the web site - but I might be biased!--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Do you think education matters?
quote:
No ability to work things out. how often have you heard 'but the book says...'*I didn't do anything...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Who controls SQL language?
quote:
ahhh, Frank.Should have guessed you'de be here. You seem to do less work than me. If that's possible?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Who controls SQL language?
Hi Crispin,
quote:
I was having an argument with a co-worker. He said that the W3C controlled SQL.As far as I can see on...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Best practice when to use an index
Hi Jeremy,
quote:
If I understand things correctly, using an index is at least 2 reads - one (or more) for the index and...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Date Function
Hi rmilford,
quote:
today -1.what about
declare @mydate datetime
set @mydate = getdate()-1
print @mydate
?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: I suggest not using black-on-black for registratio
quote:
It may be a problem with settings on your computer. I've never seen the forum nor the registration page as 'black-on-black'.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Thanks for this site ! Any similar for Oracle
Interestingly I've found an Oracle forum on
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Best practice on table design
Hi Tim,
quote:
But in practice, using variable length columns means that row size will typically be much smaller than the maximum. You need...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: In Trouble - Access with SQL Server (ODBC)
Hi Tom,
could it be you're using bit field in SQL Server without a default value?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Best practice when to use an index
Hi Tim,
quote:
I'd say it depends how wide the tables are. If they are just: surrogate key(PK ID int column), Param name (%char),...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Best practice when to use an index
Hi crosspatch,
quote:
Interesting question. I guess the answer is six of one and half a dozen of the other.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
how often have you heard 'but the book says...'RE: Performance - too many columns
Hi Patrick,
I've never experienced performance issues with 'large' tables, but when your table design goes beyond 4KB, only one row can be stored in a page. The rest is wasted...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
RE: Hyper-threading
Hi Markus,
quote:
HI Steve, I haven't done any benchmarking myself but I remember an article telling that hyperthreading gives you about 1.2 times...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 4,816 through 4,830 (of 5,356 total)