Viewing 15 posts - 76 through 90 (of 93 total)
I think u've answered ur own question there ... in that you cannot have an indexed view that contains a UNION statement! if u actually look at the rules for...
January 4, 2005 at 4:29 am
Have a look in BOL under Indexed Views ... theres a pretty big section on it! In my opinion though, they really aren't worth the effort and i'd devise another...
December 21, 2004 at 4:20 am
"Well, i can assure you that it's free"
We had this discussion in another thread ... Be careful what ur saying ... Reporting server has to RUN ON A SERVER THAT...
December 10, 2004 at 4:57 am
The IBM website will have it ... although not sure why u'd want it ... god awful, non COM+'able UNIX based piece of cr@p it is!? Well, last time...
December 8, 2004 at 8:12 am
as long as you're not building SQL statements anywhere in the process (eg. Neither the SPROC, ADO etc) then you will be fine again SQL Injection! As long as Parameters...
December 2, 2004 at 10:02 am
only for fun ... and occasionally add a reply to his postings (C&P'ed from a notepad file now!! ) saying "if you dont...
December 1, 2004 at 4:32 am
As Reporting services is a web-service based application, you are likely going to need to be careful about restricted characters. I haven't ran into the problem (yet!) myself, but you're...
December 1, 2004 at 3:49 am
do what the rest of us do ... buy a couple of per-processor licenses and then pray ur covered!? SQL Server licensing documentation is harder to read than the Bible...
December 1, 2004 at 3:42 am
Ignore Joe ... to be fair, the tone he's taken here is actually quite mild in comparison to what he puts in the MSDN newsgroups! what i do always find...
December 1, 2004 at 3:31 am
ooops ... been misinformed on THAT one!
Right ... everyone .... be VERY VERY quiet!!
November 17, 2004 at 4:05 am
You dont need ANOTHER license to run reporting services. The only license needed is for the SQL Server you are pointing at ... reporting services is esentially a freeby. It...
November 17, 2004 at 3:45 am
Yes and Yes!
You can either drop and recreate them or use the DBCC INDEXDEFRAG ... which sometimes isn't QUITE as good, but...
October 15, 2004 at 2:19 am
If you're using the same shared storage unit, having a seperate partition for the TRANSACTION logs isn't going to make a massive difference performance wise because it's still using the...
October 14, 2004 at 4:29 am
Not sure why you're having to prove the worth of Indexes to the rest of ur team, but hey!?
What you should see...
October 14, 2004 at 4:16 am
Viewing 15 posts - 76 through 90 (of 93 total)