Viewing 15 posts - 3,391 through 3,405 (of 8,761 total)
Rudyx - the Doctor (7/26/2016)
select @CoverUp = ['True'|'False'] --> make your choice
if CoverUp = 'True'
...
July 27, 2016 at 1:12 am
Post what you have tried and the errors
😎
July 26, 2016 at 11:59 pm
Piling on, sp_Blitz is good but one must thoroughly validate all settings and configurations on the servers in such a situation. Far too often have I seen simple mistakes like...
July 26, 2016 at 10:46 pm
The calculation is quite simple, divide the number by 1000 to get the year and the add the remainder of the division - 1 as days, here is a quick...
July 26, 2016 at 10:38 pm
Quick question, you have TF-1118, why not also TRACE FLAG 1117 – equal growth of files in a filegroup?
😎
July 26, 2016 at 2:06 pm
Piling on, nmap network scanner[/url] will do nicely discovering any services on a network including SQL Server instances
😎
July 26, 2016 at 1:17 pm
Sean Lange (7/26/2016)
Jack Corbett (7/26/2016)
July 26, 2016 at 1:09 pm
Best practice is to set the database in a single user mode when changing the compatibility level to prevent cross level compilation and incorrect / bad plans being cached. Changing...
July 26, 2016 at 8:57 am
Piling on, the demonstrated expected output does not fit the description, can you please clarify?
😎
July 26, 2016 at 8:47 am
Quick suggestion, post the actual execution plan and the full specs of the server
😎
July 26, 2016 at 8:36 am
Piling on, one of the fastest ways of doing this is to use Window Function with the appropriate POC index
😎
IF OBJECT_ID('tempdb..#tab1', 'U') IS NOT NULL
DROP TABLE #tab1;
CREATE...
July 26, 2016 at 5:31 am
This should be fine but preferably no activity should take place in the databases during the upgrade.
😎
July 26, 2016 at 12:47 am
Quick question, are you specifying either -c character type or -w wide character type
😎
July 25, 2016 at 10:40 pm
Quick question, what is the output data type?
😎
This task is trivial and a simple conversion to SMALLDATETIME should do the trick
DECLARE @DT DATETIME = GETDATE();
SELECT
...
July 25, 2016 at 10:30 pm
naren.ece2012 (7/6/2016)
We are getting error while taking backup of a database on local Drive( Operating system error 1117 (The request can not be performed because of I\O device error)).
Details
SQL...
July 25, 2016 at 10:10 pm
Viewing 15 posts - 3,391 through 3,405 (of 8,761 total)