Viewing 15 posts - 1,651 through 1,665 (of 7,191 total)
Step 1 = schedule logic
Step 2 = sp1
Step 3 = sp2
Step 4 = sp3
Presumably where you are the first business day of the month is...
April 3, 2017 at 8:04 am
Use xp_cmdshell to call the PowerShell command from a stored procedure. That's probably the simplest way.
John
April 3, 2017 at 5:33 am
I know next to nothing about Oracle, but I'd guess that "integrity constraints" might include data types and check constraints as well as primary and foreign keys. Have you tried...
April 3, 2017 at 5:22 am
Sounds like a job for PowerShell. The PowerShell commands come with the AD client tools, if I remember correctly. Or you could set up a linked server to AD and...
April 3, 2017 at 5:16 am
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
Viewing 15 posts - 1,651 through 1,665 (of 7,191 total)