Viewing 15 posts - 1 through 15 (of 25 total)
I will test it just for the kicks and post back the results. I'd be surprised if omitting semi-colon mattered in this case.
Yeah sorry the ALTER DATABASE after the RESTORE...
July 5, 2017 at 8:00 am
Thank you.
I will try to use this. I think this would solve the issue.
July 5, 2017 at 7:56 am
Had a look at "Application Roles".
I think this is what we are looking for. Will try out and post back if the objective gets achieved or not.
There are some gotchas...
June 15, 2014 at 1:28 pm
Grant Fritchey (3/13/2014)
March 14, 2014 at 4:45 am
free_mascot (3/13/2014)
Not always but yes most of the time.
Hi, Is your comment on the quoted article text or are you saying we can determine the cost of matching plan with...
March 13, 2014 at 5:20 am
Assume there is no way to achieve this?
February 17, 2014 at 10:51 pm
granting a login these two permissions is probably what you are after:
GRANT VIEW SERVER STATE TO [domain\lowell]
GRANT VIEW ANY DATABASE TO [domain\lowell]
Thanks Lowell.
But that still does not give me view...
February 13, 2014 at 10:07 pm
SELECT DISTINCT dbPatCnt,dbSchTypeCnt,(SELECT MAX(dbSchDate)) AS dbSchDate
FROM dbo.SchDetail
GROUP BY dbPatCnt, dbSchTypeCnt
How do I code his so that it only returns the dbSchTypeCnt for the max(latest) dbSchDate?
thanks,
Assuming you are on SQL Server...
February 13, 2014 at 11:04 am
Hi,
I know this is a very old post, but out of curiosity, how did you determine that data in the nvarchar, nchar columns does not have unicode specific characters?
I also...
February 4, 2014 at 1:48 am
Thanks Gail for your reply, but what do you think about partitition elimination for performance benefit?
Also, I would really like to know your view on the actual question of the...
June 20, 2013 at 4:38 am
Thank you WolfgangE and opc.three for your replies.
I think I will use a mixed approach where I'll use individual partition schemes for larger high impact tables, while for smaller ones...
June 11, 2013 at 3:28 pm
Vedran Kesegic (3/27/2013)
Yusuf Ali Bhiwandiwala (3/27/2013)
Vedran Kesegic (3/26/2013)
Heap should have no indexes. Try with TABLOCKX hint.
Hi Vedran,
I couldn't quite connect your two sentences:
"Heaps should have no indexes" (heaps can...
March 27, 2013 at 2:17 pm
Agree with Sean on providing the schema, sample data and expected output given the sample data.
I have taken the liberty though, to come up with some sample test data looking...
March 27, 2013 at 1:41 pm
I figured out the reason why minimal logging was not being done in my case.
All the pre-requisites mentioned in BOL to achieve minimal logging were met.
Though, a few hours later...
March 27, 2013 at 12:53 pm
Vedran Kesegic (3/26/2013)
Heap should have no indexes. Try with TABLOCKX hint.
Hi Vedran,
I couldn't quite connect your two sentences:
"Heaps should have no indexes" (heaps can have non clustered indexes, can't...
March 27, 2013 at 12:38 pm
Viewing 15 posts - 1 through 15 (of 25 total)