Forum Replies Created
Viewing 15 posts - 2,341 through 2,355 (of 6,676 total)
-
RE: Database stuck in recovery
SQLNewbie_01 - Wednesday, January 16, 2019 2:55 PMJeffrey 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 -
RE: Let SQL do the work ?
A couple of issues you have with this query. First - you should join on the OperatorID and not the name (in fact - the name should not be in...
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 -
RE: Restored SSRS not working
Did you apply the certificate from the old 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 -
RE: count by fiscal quarter
drew.allen - Monday, January 14, 2019 12:25 PMLynn Pettis - Monday, January 14, 2019 10:15 AMRE: 3rd Party Backup Tools
This is a physical server in a cluster - the storage is an Enterprise SAN and we have multiple data drives and mount points configured. I also have...
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 LogsRE: 3rd Party Backup Tools
Are you really still on 2005? If so - then any of the utilities here will be worth the expense - as every one of them can stream the backup...
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 LogsRE: Database refresh from Production DB to Test DB in Sql server 2014
poratips - Saturday, January 12, 2019 12:12 PMJeffrey 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 LogsRE: Count mismatch in validation
No - these are not the same...the first one excludes all claims on 2006-01-01 where the eff_date is not 9999-12-31. The second one includes only those claims where the claim...
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 LogsRE: Database refresh from Production DB to Test DB in Sql server 2014
poratips - Saturday, January 12, 2019 9:08 AMJeffrey 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 LogsRE: New Reporting Services Installation
Do you anticipate - at any time in the near future - scaling your SSRS environment out to multiple servers to load balance report access and generation? If 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 LogsRE: substring with Charindex
If you don't know the order - and want just the first 4 values:
Select @string
, max(Case When i.ItemNumber = 1 And i.Item2 =...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 LogsRE: substring with Charindex
drew.allen - Tuesday, January 8, 2019 2:06 PMJeffrey 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 LogsRE: Trying to add a running total to my query
For a running total - you need to set the row boundaries in the windowing function so that row only calculates for the data from the beginning to the current...
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 LogsRE: DbccLOBCompact on table with no LOB datatypes
Here is a nice write up: https://sqlity.net/en/1051/blob-and-row-overflow-storage-internals-row-overflow-data/
Even if you don't have LOB data - if you exceed the maximum size of a page the data can be moved...
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 LogsRE: Does Stored Proc Complete if Machine Rebooted?
Eirikur Eiriksson - Sunday, January 6, 2019 10:06 AM
