Viewing 15 posts - 21,541 through 21,555 (of 22,189 total)
The one time I did manage a VLDB, we sure has heck ran the log backups more frequently than once a day, but then it was an OLTP system. I'm...
November 1, 2007 at 12:43 pm
Bob Fazio (11/1/2007)[hrComplaints come from many sources. A stable system is a good goal too. Performance is also a goal. If you haven't noticed before a high...
November 1, 2007 at 9:37 am
Please, a syntax check on the XQuery. It's my first time out of the gate with this and I'm not sure I'm avoiding stupidity successfully.
November 1, 2007 at 6:00 am
Neither full text or xml has me terribly excited. If it were my project, I'd be reexamining the assumptions and trying to find a method of defining the requirements more...
November 1, 2007 at 5:20 am
What about XML for the meta data? It really does sound like it's only semi-structured data.
October 31, 2007 at 6:58 am
I'm sorry, I don't understand the question. Can you supply a few more details?
When you say in-lined table function, do you mean a user defined function that returns a table...
October 31, 2007 at 6:54 am
Well, again, there's not enough detail to start to give you very specific answers. It sounds like you're doing RBAR (row by agonizing row) processing. I'd strongly suggest you examine...
October 31, 2007 at 6:47 am
Andras Belokosztolszki (10/31/2007)
Grant Fritchey (10/30/2007)
October 31, 2007 at 5:51 am
Marcus Farrugia (10/30/2007)
What is the difference between if and iif?Thank you in advance for your help.
IIF is an MDX expression used to build cubes. It corresponds to the immediate if...
October 30, 2007 at 1:02 pm
This works:
create table #t
(Col1 nvarchar(50))
GO
create table #s
(Col1 nvarchar(24)
,Col2 nvarchar(24)
)
GO
insert into #t (col1) values ('a')
insert into #t (col1) values ('b')
insert into #t (col1) values ('c')
insert into #t (col1) values ('d')
insert into...
October 30, 2007 at 12:59 pm
No. Analysis Services is for cubes. Totally different application. You just need to do the stuff in the post above to identify the appropriate SPID and then use the command:
KILL...
October 30, 2007 at 12:02 pm
Adding the other column will only help if it turns the index into a covering index. If you're doing SELECT *... I probably won't do anything.
October 30, 2007 at 10:04 am
Shy details, it sounds like you're talking about temporary tables.
October 30, 2007 at 9:03 am
Viewing 15 posts - 21,541 through 21,555 (of 22,189 total)