Viewing 15 posts - 11,131 through 11,145 (of 59,064 total)
Reminds me of a previous boss of mine in the 1990s when talking about...
September 21, 2018 at 8:48 am
below86 - Friday, September 21, 2018 7:50 AMYou could try this:
CONVERT(CHAR(11), DateIn, 107) AS DateIn
107 is going to have a comma in...
September 21, 2018 at 8:47 am
September 21, 2018 at 8:41 am
September 21, 2018 at 8:30 am
September 21, 2018 at 8:18 am
September 21, 2018 at 8:15 am
September 21, 2018 at 8:14 am
September 21, 2018 at 8:13 am
We have a couple of 2.2 TB database and it's that large because of a very common problem in the industry... people use RDBMSs as a "keep it forever" file system. The...
September 21, 2018 at 8:05 am
Give the users a spreadsheet where they can click a button, have it run a stored procedure, and put the results in the same spreadsheet. Removes the onus from you...
September 21, 2018 at 6:59 am
In that case, that's only a little more 600,000 rows per month. Perhaps partitioning by month would help in that you could simply and nearly instantly SWITCH out the oldest...
September 20, 2018 at 12:22 pm
September 20, 2018 at 12:08 pm
The production does have documentation. Here's the link...
https://library.nagios.com/#_ga=2.8857777.504434982.1537451559-493762336.1537451559&_gac=1.212987168.1537451559.EAIaIQobChMInPrfnd3J3QIVmUsNCh1nMwjfEAAYASAAEgL7IvD_BwE
September 20, 2018 at 7:55 am
Viewing 15 posts - 11,131 through 11,145 (of 59,064 total)