John Mitchell-245523

Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 7,187 total)

RE: Log Shipping across two non-domain related networks - restore error

sc-w - Tuesday, January 24, 2017 4:06 AM
Are you saying have the mapping going from destination B to source A...

January 24, 2017 at 4:12 am

#1924581
RE: Log Shipping across two non-domain related networks - restore error

sc-w - Tuesday, January 24, 2017 3:08 AM
Hi,
I have a need to setup log shipping across...

January 24, 2017 at 3:35 am

#1924568
RE: Memory Pressure is HIGH in PROD Environment

Narine M - Tuesday, January 24, 2017 3:16 AM
John Mitchell-245523 - Tuesday, January 24, 2017 3:10 AM

January 24, 2017 at 3:25 am

#1924565
RE: Memory Pressure is HIGH in PROD Environment

Narine M - Tuesday, January 24, 2017 3:03 AM
John Mitchell-245523 - Tuesday, January 24, 2017 2:59 AM

January 24, 2017 at 3:10 am

#1924560
RE: Memory Pressure is HIGH in PROD Environment

Definitely check your max server memory, yes. If you're not running any other applications or SQL Server components on the server, leave about 8GB for the operating system.

January 24, 2017 at 2:59 am

#1924552
RE: Create SQL FullText statement via VB.Net

OK, so you either get double quotes or no quotes! I don't know enough about VB to guess why that is. As a kludge, you could do a replace...

January 24, 2017 at 2:55 am

#1924549
RE: Sql Query for retriving proper data based on join condition

Great job on posting the sample data, but your query has several invalid object name errors in it. If you could post a query that runs (even if it...

January 24, 2017 at 2:49 am

#1924546
RE: pipe result to a .csv or .txt files

You could try the Export-CSV cmdlet if Out-File doesn't give the flexibility you need.
John

January 24, 2017 at 2:42 am

#1924544
RE: Create SQL FullText statement via VB.Net

Is it as simple as just removing the ControlChars from your VB code?
Dim fltrStr As String = "Contains(dbcode, '" & "*3*" & "')"
John

January 24, 2017 at 2:37 am

#1924543
RE: Patch Principal and Mirror at The Same Time

Yes, and in the unlikely event that something goes wrong, you really don't want it going wrong on both servers!
John

January 24, 2017 at 2:19 am

#1924540
RE: Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

Welsh Corgi - Monday, January 23, 2017 9:31 AM
John Mitchell-245523 - Monday, January 23, 2017 8:55 AM

January 23, 2017 at 9:41 am

#1924430
RE: Identify objects that do not use an Identity Column but a Lookup Table to generate an Unique Identifier

Welsh Corgi - Monday, January 23, 2017 8:33 AM
How should I modify this query to identify the table name?

January 23, 2017 at 8:55 am

#1924415
RE: How to get hardcoded date form table

This should help you.
John

January 23, 2017 at 8:34 am

#1924411
RE: How to get hardcoded date form table

SELECT @ret = CASE WHEN MAX(Date) IS NULL
THEN c.Value
ELSE MAX(Date)
END
from dbo.EmpDate e
JOIN Config c ON c.id = 1
where e.Sa=...

January 23, 2017 at 8:15 am

#1924403
RE: Group multiples values together

jcobb 20350 - Monday, January 23, 2017 7:38 AM
I have three stocking locations. Two are within the same physical building but considered...

January 23, 2017 at 7:46 am

#1924400

Viewing 15 posts - 1,951 through 1,965 (of 7,187 total)