Viewing 15 posts - 3,466 through 3,480 (of 49,552 total)
You want the string after the last comma?
The one before the last comma would be LoanDate
DECLARE @str VARCHAR(250) = 'DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt'
SELECT REVERSE(LEFT(REVERSE(@str), CHARINDEX(',', REVERSE(@str))-1))
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 6:17 am
That can work.
Alternately you could aggregate the stuff you remove from the current table and just store the aggregated results if you don't need the details. Other option would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 5:41 am
prettsons (3/14/2016)
Add a new file into filegroup then empty the first file by DBCC SHRINKFILE.
You can't do that if the filegroup is offline, and besides, the OP stated that the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 5:34 am
Please note: 8 year old thread, and the author hasn't logged in in 3 years.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 5:02 am
nadersam (3/14/2016)
The buffer hit ratio is always 1 or 0.99, and the buffer cache hit ratio base is highly variant.
Buffer cache hit ratio is nearly useless as a counter.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 3:43 am
Last time I saw this it did indeed turn into a catch-22 (worse in the other case as it was a production DB and the missing filegroup was completely missing)
As...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2016 at 2:51 am
You're going to have terrible performance, even if you only have one or two of those. Terrible and erratic performance.
https://www.simple-talk.com/content/article.aspx?article=2280
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2016 at 3:29 am
After the fact, you don't. At the time it occurs, you could use something like Process Explorer to identify what has the file handle open.
Make sure your antivirus is correctly...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2016 at 2:40 am
No, they're not both measuring pages read from disk. They're measuring completely different things
Memory\\Pages/sec is the rate at which pages are read from or written to disk to resolve hard...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2016 at 2:37 am
Did you try the documentation? https://msdn.microsoft.com/en-us/library/ms189788.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2016 at 6:05 am
The nonclustered index is smaller, since it doesn't have the name column in it. Hence for a query that only references the ID column anywhere, the nonclustered index is slightly...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2016 at 3:24 am
There is no solution to that. A log file is unlikely to contain all of the changes made back to the DB's creation, and you can't play it forward alone....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2016 at 3:02 am
Full and log can run at the same time, so can diff and log. Diff and full block each other, so which ever starts first will run to completion first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2016 at 1:58 am
risingflight143 (3/7/2016)
I am running out of disk space so i need to cleanup
Then look for old files you can delete or move, and ask about getting more drive space.
Shrinking DBs...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2016 at 1:57 am
Defaults. When you're creating a row and a column should go to a particular value, use defaults. If you need to set a column to a particular value when the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2016 at 1:50 am
Viewing 15 posts - 3,466 through 3,480 (of 49,552 total)