Viewing 15 posts - 76 through 90 (of 1,079 total)
Simple answer, yes you can reduce the size if the space is available.
It shrinking advised? No.
Refer to methods: https://support.microsoft.com/en-us/help/307487/how-to-shrink-the-tempdb-database-in-sql-server
Question though, why is your tempdb on the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 2, 2017 at 8:59 am
I don't see any code you developed to link any re-admissions to the original case nrs, but I'll get you started on determining the days between admission and discharge dates. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 30, 2017 at 4:49 pm
.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 26, 2017 at 2:05 pm
This is based on current date, you'll need to replace 'getdate()' with the date you are working with'
SELECT datepart(year, CAST(DATEADD(dd, -1, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()),...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 26, 2017 at 11:58 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 3:32 pm
We have a similar setup.
The one challenge so far was load balancing unexpected workloads on instances, because you are now sharing one resource pool between all Instances.
Other...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 3:05 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 2:16 pm
Question, why aren't you using the perfectly good SQL Maintenance plans to perform all of this?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 2:10 pm
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 12:54 pm
That should create a new backup for DAILY, since you have the @fileDate portion in the filename.
@fileDate is set to be a yyyymmdd format, so you'll be writing to the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 12:32 pm
How to demostrate, that one solution based on vm high availability is not the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 11:26 am
Yes.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 25, 2017 at 7:56 am
Played around with it, can honestly not say I see an immediate use for it in my own life, but considering other similar products are doing this, it just makes...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 24, 2017 at 1:54 pm
Your INNER JOINS on Orders Orders ORD ON ORD.OrderID = ORDD.OrderID INNER JOIN rule out rows that don't match.
Consider a LEFT OUTER join to return unmatched orders...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 24, 2017 at 10:27 am
To build trends in behavior over time, why your logspace is used and can't be reused, include checking log reuse reason with it maybe (suggestion)
select name,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 24, 2017 at 9:16 am
Viewing 15 posts - 76 through 90 (of 1,079 total)