Viewing 15 posts - 196 through 210 (of 497 total)
ChiragNS (10/22/2009)
The table name and the synonym name would be different. You will have to change the code wherever you have coded with the tablename
Not at all. I...
October 22, 2009 at 5:15 pm
That's why I'm suggesting the table pairs with a synonym to flop between the two... you can take your time building the table and the indexes (will go faster because...
October 22, 2009 at 12:28 am
Elliott W (10/20/2009)
I think you should find out what is wrong with the underlying objects structures. ie, figure out...
October 22, 2009 at 12:24 am
No, the view is for the primary app.
October 20, 2009 at 4:21 pm
I am experimenting with triggers at the moment, but any data load (via triggers or with something else) is going to cause index fragmentation and page splits. They are...
October 20, 2009 at 1:28 am
They don't want any latency, so after the data is loaded or the records inserted individually (in case of user generated content), they have to be visible on the site,...
October 20, 2009 at 1:04 am
Quite often, it may be every night sometimes. And lots of data... This causes a lot of page splits on the indexes.
BTW, the underlying tables have to be...
October 20, 2009 at 12:59 am
It does a bit, but too many of the queries use the indexed view and would not be fast enough without it.
I am trying to do the same:...
October 20, 2009 at 12:47 am
The tables are pretty big, even the base ones, not to mention the de-normalised ones, so the re-index may take 40 or more minutes.
Yep, this is what I was after....
October 20, 2009 at 12:11 am
I have an indexed view, which is a de-normalised structure to speed up queries on the database. Everything goes well until the data loading happens. Lots of data...
October 19, 2009 at 11:35 pm
Found it out. In the script that SQL Server generates, the second article is passed as: @article = N'ErrorLog1'. So I just added the schema name to the...
October 13, 2009 at 7:18 pm
My data is pretty static, so I am not worried about dirty reads and other evils of (nolock), but want to use it to my advantage.
So, back to...
October 12, 2009 at 9:14 pm
philip-seamark (10/1/2009)
You could convert the sql statement inside your proc to be dynamic SQL. That way the compiler won't check.
I guess this would work, but it involves to many...
October 1, 2009 at 7:01 pm
bitbucket-25253 (10/1/2009)
CREATE PROCEDURE Dbo.Garbage
AS
SELECT *...
October 1, 2009 at 6:59 pm
But SP:StmtStarting does not show duration. I guess I should be using SP:StmtCompleted instead.
September 30, 2009 at 1:40 am
Viewing 15 posts - 196 through 210 (of 497 total)