Viewing 15 posts - 151 through 165 (of 1,199 total)
And so,Is there any way that I can fetch both at the same time(so that it can be completed in 6 mins only).
So did you look at my suggestion for...
April 20, 2020 at 8:37 pm
To be honest: I don't think it is with Bind's realm to optimize the view - but it is an advice (s)he can forward to the manager.
April 20, 2020 at 7:49 pm
Yes, attempting to optimize the view is the way to go. When I first got the notification for this thread, I though that there is something fishy here. If it...
April 20, 2020 at 7:20 pm
The old system tables are now compatibility views for those that have old scripts running. There is a particular reason the old views may not work well here: in those...
March 19, 2020 at 7:56 pm
That query is so... SQL 2000. Here is a mordernised version:
SELECT 'ALTER TABLE ' + quotename(s.name) + '.' + quotename(o.name) +
...
March 18, 2020 at 9:55 pm
ALTER DATABASE COLLATE only changes the default collation and the collation of the tables in the system catalog. I got the impression from your post that all the user-table columns...
March 18, 2020 at 7:58 pm
You are probably hit by the fact that SSMS opens a second connection for Intellisense. Do this:
ALTER DATABASE DB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE DB COLLATE...
March 18, 2020 at 8:20 am
Going back to the original question, and the origin of the query. What you can track in SQL Server, with Trace or whatever is the application name, which is something...
March 13, 2020 at 9:36 pm
Does it happen with a specific stored procedure, or just in random places in the application?
Is the SQL Server instance local to your machine, or is on a different server?
To...
March 5, 2020 at 8:33 am
What edition of SQL Server do you have? The optimizer will only consider indexed views in Enterprise Edition. The only way an indexed view can be used in Standard Edition...
March 4, 2020 at 10:11 pm
We can't tell if you should add more columns to that view - we know nothing about your system.
And I am not sure that an indexed view will actually work...
March 4, 2020 at 8:47 pm
Find an idle, freshly started instance. Run this:
SELECT * FROM sys.dm_tran_version_store
to verify that it is empty. Then do something like this in a database that does not have any form...
March 3, 2020 at 8:49 pm
The inserted/deleted tables are created from the version store in tempdb.
So that is indeed one more input to the original question. If you are running with any sort of snapshot...
March 3, 2020 at 3:24 pm
In my case the char(7200) was just a filler to the sake of the test. Let it represent some umpteen other columns. Probably not totalling 7200 bytes, but maybe a...
March 2, 2020 at 10:30 pm
I should add one more thing. I conducted some tests to back what I said, and they gave me some results that it took some time to digest. But there...
March 2, 2020 at 10:00 pm
Viewing 15 posts - 151 through 165 (of 1,199 total)