Frank Kalis

Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 5,356 total)

RE: SQL Anywhere

Well, I've downloaded it. After all, it's free or not?
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 5:21 am

#479847
RE: formatting numbers

I'll stick with Jonathan's suggestion.
That's job of the client app, not the server.
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 5:20 am

#479846
RE: Veritas banner

It's all about money!
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 5:19 am

#479844
RE: Examples using Table Variables

quote:
I'm wanting to load a table variable with a query result set ... and then pass the table variable to a function....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 2:25 am

#479825
RE: RowNum Function in SQLServer

Somehow the first one seems to be broken I meant
http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 1:33 am

#479818
RE: RowNum Function in SQLServer

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 1:31 am

#479817
RE: Security Question

Not sure about hacking, but it doesn't look normal
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 1:25 am

#479815
RE: Pet Peeves

The change from central european summertime to winter-?!?, normal time. *?@x`*§%
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 12:44 am

#479812
RE: Veritas banner

No, that's where I 'borrowed' Antares answer. Originally he posted it here
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14025
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 12:32 am

#479810
RE: sysprocesses::nt_username Empty

Any chance to collect this information from the client app(s)?
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 12:18 am

#479806
RE: Veritas banner

And that's one thing I really appreciate every day !!!!
Btw, the book is in my opinion a 'nice to know' surely no 'must have'.
Can't find the thread right now, but...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 28, 2003 at 12:16 am

#479805
RE: procedure naming prefixes

Found it
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 27, 2003 at 9:08 am

#479698
RE: procedure naming prefixes

I think Brian Kelley did an article on this. Look at Resources -> Columnists -Brian Kelley.
Frank
http://www.insidesql.de
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 27, 2003 at 9:06 am

#479697
RE: sysprocesses::nt_username Empty

AFAIK when you use SQL authentication mode, SQL Server will not be aware of NT accounts.
Frank
http://www.insidesql.de
Edited by - Frank Kalis on 10/27/2003 09:03:18 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 27, 2003 at 9:02 am

#479694
RE: data type declaration for a column

I would suggest a varchar or - if you are sure that almost all telefone numbers do have the same length a char column.
Why?
Well, I'm not familiar with US telefone...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

October 27, 2003 at 8:59 am

#479691

Viewing 15 posts - 3,646 through 3,660 (of 5,356 total)