Viewing 15 posts - 3,121 through 3,135 (of 7,187 total)
You need to change it in the WHERE clause, not in the subquery.
John
July 13, 2015 at 8:16 am
If, as it seems, you're trying to fill the gaps in a sequence, create a numbers table[/url], left join it to your table, and set the value of B in...
July 13, 2015 at 3:48 am
How big is the largest table in each database? Is it possible that a query is coming along every now and then that does a table/clustered index scan against...
July 13, 2015 at 2:09 am
Are you restoring databases on the server, or rebuilding indexes?
John
July 10, 2015 at 9:30 am
OK, even if you've tested your DR plan and you have proved that you can recover to fulfil the required RPO and RTO (recovery time objective and recovery point objective),...
July 10, 2015 at 2:16 am
What is the exact wording of your business requirement? Taking transaction log backups at the same frequency as full backups is useless and you may as well just put...
July 9, 2015 at 4:09 am
First, don't use the append existing option, or you'll end up with a single file with dozens of backups in it.
Second, have separate maintenance plans for full and log backups,...
July 9, 2015 at 2:37 am
Well, you say they're unused and unneeded, so I'd say that dropping them would be the kindest thing. Unless they're clustered indexes, that is, but then they wouldn't be...
July 8, 2015 at 9:57 am
Just use DROP INDEX. Since you're dropping them, there's nothing to rebuild.
John
July 8, 2015 at 9:34 am
Yes, it's independent. You're probably best off fixing on SQL Server storage or file storage and sticking with it, so that you don't get too confused and have lots...
July 8, 2015 at 5:04 am
SELECT
SCHOOLID
,MAX(STATUS) STATUS
FROM #TEMP
GROUP BY SCHOOLID
ORDER BY SCHOOLID
John
July 7, 2015 at 7:24 am
Start from the inside and work your way out:
DECLARE
@minutes int = 17562
,@minportion int
,@hours int
,@hourportion int
,@days int
,@ddhhmm char(8)
SET @minportion = @minutes%60
SET @hours = (@minutes - @minportion)/60
SET @hourportion = @hours%24
SET @days =...
July 7, 2015 at 7:12 am
You need to do regular (more than daily log backups) not just to control the size of your log, but also to enable point-in-time recovery should it be needed. ...
July 7, 2015 at 4:54 am
You need to find some way of enumerating the files in the folder and then processing them one by one. That may be by running a dir command via...
July 7, 2015 at 4:37 am
Not sure what you don't understand. Say you have 17562 minutes. Then the minute portion of that period is 17562 % 60, or 42. Now subtract that...
July 7, 2015 at 4:28 am
Viewing 15 posts - 3,121 through 3,135 (of 7,187 total)