Jeffrey Williams

Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 6,676 total)

Reply To: Always on

Admingod wrote:
Secondary Replica 2 (same location Sync mode for fail over) - Allow some users to do select queries so no one should run any queries in Primary, would this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 6, 2020 at 9:39 pm

#3712930
Reply To: func_GetInvoiceNumberByDocumentNumber
This is essentially the same as Frederico's first option:
```
Declare @startDate date = (Select max(co.EntryDate)
             ...
```
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 6, 2020 at 9:31 pm

#3712900
Reply To: Availability groups

No - you cannot setup an availability group between versions like this and you cannot make the databases read/write on the secondaries. At best you can make the databases read-only...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 6, 2020 at 7:51 pm

#3712820
Reply To: Setting flexible security for reporting

You should review this article: http://www.sommarskog.se/grantperm.html
There are several options available for EXECUTE AS - but to be safe I would recommend using a certificate and signing your procedures with that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 5, 2020 at 5:07 pm

#3712445
Reply To: Msg 112303, Level 16, State 1, Line 0 Failed to login to SQL Server

Litespeed executes from an extended procedure - which creates a new connection to the database to perform the backup. By default, the service account running SQL Server Agent does not...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 4, 2020 at 4:33 pm

#3712383
Reply To: Using Visual Studio instead of Report Designer

No - there isn't a way to make Visual Studio work the same as Report Builder...and you really don't want to do that. The benefit of using SSDT is that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 3, 2020 at 6:05 pm

#3712195
Reply To: The directory creation time

jkeefe wrote:
Actually, this makes perfect sense to me. The CreationTime is a property of the $directory object. In the quoted string, $directory.CreationTime cannot be determined because the parser doesn't recognize...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

January 2, 2020 at 11:05 pm

#3711982
Reply To: Error converting data type varchar to numeric.
Use CONCAT instead of the plus sign - CONCAT will take care of converting to the appropriate data type for you.
, CONCAT(a.sku, p1.SHORT_DESC, ' ', p1.LONG_DESC1) AS short_description
```
Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs
```
January 2, 2020 at 7:05 pm

#3711942

Reply To: persisted computed column error

I would recommend using CONCAT instead of the plus sign...it will simplify the code:

CONCAT(master_id, company_code, FileLocation_FileBeginsWith, despatch_group
     , convert(char(8), isnull(despatch_group_start_date, '19000101'), 112)
 ...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

January 2, 2020 at 5:55 pm

#3711903

Reply To: Difference between where and INNER JOIN comparing a value

For an INNER join there is no difference - and you can validate that by viewing the execution plan generated from each statement.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 31, 2019 at 5:21 pm

#3711504

Reply To: Intermittent issue with cluster failover when SQL Agent service is restarted

How are you stopping/starting SQL Server Agent - and why is that something that needs to be done on a regular basis?

If you are using the services applet to stop/start...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 30, 2019 at 7:02 pm

#3711263

Reply To: Truncate or Insert data with conditions

Jonathan AC Roberts wrote:

You just need BEGIN/END around the statement.

Also, it will be more efficient to use EXISTS than SELECT COUNT(*).

IF EXISTS(SELECT * FROM [A]) BEGIN

   ...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 24, 2019 at 4:43 pm

#3710261

Reply To: [SOLVED]Migrating databases - error on login 4064 (cannot open default database)

You need to use something like this: ' + convert(varchar(85), Sid, 1) + '

You don't convert to a varbinary and then concatenate to a string - you need to convert...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 24, 2019 at 4:10 pm

#3710257

Reply To: is there any better way to export SQL server data into csv file?

WILLIAM MITCHELL wrote:

The OP stated "I want to make a report to let user export data from SQL Server database" so why not consider SSRS?

This also has the benefit of allowing...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 23, 2019 at 6:18 pm

#3710078

Reply To: [SOLVED]Migrating databases - error on login 4064 (cannot open default database)

The users in the database were originally created on the source system - and were created with a specific SID. When you restore that database to a new system -...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

December 23, 2019 at 6:11 pm

#3710075

Viewing 15 posts - 2,056 through 2,070 (of 6,676 total)