Viewing 15 posts - 3,466 through 3,480 (of 49,571 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))
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...
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...
March 14, 2016 at 5:34 am
Please note: 8 year old thread, and the author hasn't logged in in 3 years.
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.
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...
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
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...
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...
March 11, 2016 at 2:37 am
Did you try the documentation? https://msdn.microsoft.com/en-us/library/ms189788.aspx
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...
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....
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.
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...
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...
March 9, 2016 at 1:50 am
Viewing 15 posts - 3,466 through 3,480 (of 49,571 total)