Forum Replies Created
Viewing 15 posts - 1 through 15 (of 1,079 total)
-
RE: AG failover script during real DR situation
You will need to perform a manual forced failover on the 3rd DR replica.
Have a read here , but basically you will need to failover choosing with or...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Basic availability group
Yes, with Basic Availability Groups you can only have 1 x database and IP assigned per BAG.
If you applications needs 1 x connection string/listener name, BAGs won't work for...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Need Help to convert DATETIME result into DATE on SQL Server
Your issue is that the Date supplied '0001-01-01' results in out of range error, as it is less than the minimum DATE value accepted.
Minimum Date should beDECLARE...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Resource Groups
The answers did not satisfy the options.
If you chose the "Classic deployment" approach, the answer could have been Azure Resource Groups focused and be wrong anyway.Answers lacked...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: exec sp_whoisactive + cpu
You could make use of WMI query and alerting by starting sp_who2 embedded in a SQL Agent job.
Just modify the threshold duration and utilization load percentage as required.
After...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: I can't insert Arabic Text with Braces
When I copy and paste your post in normal notepad:
and SSMS:
Have you played with regional settings and Language on the OS level? (stab in...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: How do I have dbo?
what roles is this group a member of?
My account is in the BUILTIN\Users Windows Group. This group has not been assigned any server roles.
Check 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 -
RE: How do I have dbo?
run the following to review your server permissions:
SELECT pr.principal_id, pr.name,
pr.type_desc, pe.state_desc,
pe.permission_name
FROM sys.server_principals AS pr JOIN sys.server_permissions AS pe
ON pe.grantee_principal_id...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: Database Scoped Configuration
Nice question, thanks Steve
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: output time only
Yes, use
CONVERT(VARCHAR(5),TimeOfVisit,108)-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: output time only
Unsure which column you want the time only in your query, but add or replace with
cast(TimeOfVisit as TIME)
This will give you hh:mm:ss.nnnnn-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SQL Server express 2017 Limitaions
10GB is the limit for your data file.
If you have multiple data files, the limit applies to the collective sizing, so you can not have 2 x 10GB data...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: String or binary data would be truncated
Agree with you Japie, although I think there should be a function to override truncation on normal inserts.
If I understand Steve correct, we'd like something similar to SSIS, to...-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SQL Server express 2017 Limitaions
SQL Server Express does not provide the functionality to create maintenance plans, or schedule them.
Please familiarize yourself with the limitations of the Editions here-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle -
RE: SQL Server express 2017 Limitaions
You can use Ola's scripts, with Windows Task Scheduler:
How do I get started with the SQL Server Maintenance Solution on SQL Server Express?
SQL Server Express has no SQL...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 15 posts - 1 through 15 (of 1,079 total)