Frank Kalis

Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 5,356 total)

RE: Indexes

Hi Marco,
quote:
I've got some problems with SQL Server 2000 SP3: some stored procedures have got strong degradation in performance; the problem seems...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 18, 2003 at 4:04 am

#470241
RE: Concatenation

Hi Andrew,
quote:
Preethi's suggestion worked, cheers Preethi
didn't you say the LTRIM, RTRIM doesn't work for you?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 18, 2003 at 4:00 am

#470240
RE: Reindexing the system tables

Hi Gabor,
another forward
quote:
Originally posted by eyechart
First, a couple of comments:
quote:
Originally posted by shsmonteiro
Just a...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 18, 2003 at 12:52 am

#470227
RE: Reindexing the system tables

Hi Gabor,
forwarded!
...
BTW, this is an answer from Paul Randal DBCC Technical Lead, Microsoft SQL Server Storage Engine
in sqlserver public forum
"It's not possible to defragment system tables in SQL Server...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 18, 2003 at 12:52 am

#470228
RE: SQL Server Tools

Hi Brian,
quote:
Would a typical SQL Server DBA or database developer ever be willing to buy a coherent and comprehensive package of advanced...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 18, 2003 at 12:07 am

#470226
RE: Microsoft - Looking for Devs, Testers, and PMs

To piggy-back on Andy, here in Germany you are expected to contact the company first to show engagement, motivation, interest in the company, and not wait till you see an...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 17, 2003 at 11:55 pm

#470225
RE: pass list of values as parameter to stored proc

Hi Naveen,
unfortunately it is not possible to pass something like ParamArray in VB to a sproc.
However, you have two option available. Split string before passing. I think you can...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 2:28 pm

#470154
RE: Tools to calculate db size

Hi Gabor,
quote:
What do you meen by estimating the db size?
Size of the existing or a planned db?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 1:27 pm

#470147

RE: How to extract time part of a datetime field

Hi Patrick,

quote:
I wonder how long CONVERT will be around now that CAST is available. I've heard in other forums that CONVERT will...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 1:21 pm

#470146

RE: Do you think DBA is a desirable job?

Hi there,

anyone of you affected by the power shortage ?!?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 1:16 pm

#470145

RE: Help with query

Hi myoldhouse,

for relating you can use 'Outer Join'.

But, as Andrew said, what do you want to do? Can you post an example with 'real' data?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 8:01 am

#470115

RE: Concatenation

Maybe this thread can help

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12594

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 7:14 am

#470103

RE: Concatenation

Hi Dan,

funny things happen, when you think too long on an answer

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 6:58 am

#470098

RE: Concatenation

and what does DATALENGTH show you?

Is cust_id large enough to take all the data?

What about converting to varchar and then updating?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 6:57 am

#470097

RE: Concatenation

quote:
I can see what the function does by your example, but as far as I can see it returns an obvious answer,...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 15, 2003 at 6:35 am

#470092

Viewing 15 posts - 4,216 through 4,230 (of 5,356 total)