Viewing 15 posts - 1,651 through 1,665 (of 7,187 total)
The database that works, is it on the same server as the one that doesn't? Are you running both under the same login? Please will you script the stored procedure...
April 3, 2017 at 4:46 am
Any reason to be at SQL Server 2005 compatibility level? What version is the server? If you can recreate on a version that's still supported, it might be worth filing...
April 3, 2017 at 2:16 am
You haven't provided enough sample data to test this properly, but it's something like this:
AVG(MTTR) OVER (ORDER BY [FY Year], [FY Report Week] ROWS BETWEEN 12...
March 31, 2017 at 9:48 am
What do you mean by compliation lock - that's not something I've heard of? Have you tried using sp_whoisactive to trace the blocking chain to its head?
John
March 31, 2017 at 8:21 am
We've got 4 servers and they are all set up identically (apart from collation)...
March 31, 2017 at 5:17 am
Josh
Sorry, I mentioned that the clustering key ideally needs to be increasing, but another good-to-have is if it's used for range searches. IDs rarely are used for that;...
March 30, 2017 at 8:27 am
It depends on the overall width of your table and the usage patterns. If your non-clustered index is only a fraction of the size of your clustered index, and you have...
March 30, 2017 at 8:02 am
That was one of my thoughts, yes - I think we have the following possibilities:
(1) Backup somehow performed with NOINIT
(2) Backup is, for some reason, a full backup
March 30, 2017 at 5:37 am
I've never installed a service pack without the SQL Server service running. The process runs scripts and does a whole lot of other stuff, so I suspect that if SQL...
March 30, 2017 at 4:46 am
When the backup has finished, run RESTORE HEADERONLY on the backup file. How many rows do you get, and what are the BackupType(s)?
John
March 30, 2017 at 4:14 am
(1) Type "restore a database on sql2008 environment" into your favourite search engine
(2) Click on some of the ensuing links and read through them
(3) Follow the steps in...
March 30, 2017 at 3:57 am
Do you have index maintenance scheduled, and if so has it run since the last successful full backup? The reason for the size of your differential is most likely that...
March 30, 2017 at 3:34 am
You mean remote in that none of them communicate with any of the others? In that case, yes, you'll need to deploy individually. You can either develop a package for...
March 29, 2017 at 7:27 am
Paul
Yes, if you're going to deploy each individual package on the server that hosts the database it connects to. But you might consider instead putting all the packages...
March 29, 2017 at 7:04 am
The database to which you connect from a package isn't important. All that you need to make sure is that the network library you use to connect to SQL Server...
March 29, 2017 at 5:44 am
Viewing 15 posts - 1,651 through 1,665 (of 7,187 total)