Viewing 15 posts - 691 through 705 (of 5,394 total)
So, I asked a few friends and turns out that if you don't set the transaction isolation level explicitly, it takes the default, which is read committed as far as...
March 10, 2015 at 6:03 pm
I don't have a SQL instance to test right now, but here's a quick thought: try to query sys.dm_tran_locks and see which session is holding a lock on that database.
March 10, 2015 at 4:35 pm
Exactly. Maybe we should ask Paul Randal to chime in. Let me ping him and see if he can drop by.
March 10, 2015 at 4:02 pm
There are samples on Ola's site.
This should do:
EXEC IndexOptimize
@Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
...
March 10, 2015 at 11:13 am
There's no need to kick out the connection manually before you can revert to MULTI_USER. You can use ROLLBACK IMMEDIATE:
ALTER DATABASE Whatever SET MULTI_USER WITH ROLLBACK IMMEDIATE
March 10, 2015 at 10:51 am
This should do:
SELECT name
FROM #temp2 AS t2
WHERE EXISTS (
SELECT *
FROM #temp1 AS t1
WHERE id = t2.id
)
GROUP BY name
HAVING COUNT(*) = (SELECT COUNT(*) FROM #temp1)
March 10, 2015 at 10:41 am
Don't re-invent the wheel. Use Ola Hallengren maintenance solution. You can find it here: http://ola.hallengren.com
March 10, 2015 at 10:34 am
I'm sorry, but what you posted doesn't make any sense. Can you please provide some sample data and the expected results based on that sample data? You can find out...
March 10, 2015 at 10:33 am
I might add that setting up QoS helped us a lot.
March 10, 2015 at 9:04 am
Heh... My employer wouldn't be very happy to know I'm helping their competitors.
Anyway, the link speed in Australia is showing higher latency than expected (over 500 ms). We had the...
March 10, 2015 at 9:03 am
Let me guess: Formula1 team?
In that case, sorry, but I can't help you: I work for your competitors 🙂
March 10, 2015 at 8:21 am
Grant Fritchey (3/9/2015)
And, I got to meet Gianluca and Eirikur for the very first time. Total pleasure gentlemen. By the way, Gianluca is a...
March 9, 2015 at 11:46 am
You can use variations of this:
SELECT SomeColumn
FROM SomeTable
ORDER BY
CASE @Sort_Option
WHEN 'DESC' THEN NULL
...
March 9, 2015 at 9:30 am
You have to buy 10 core licenses. Problem is, SQL Server 2008 is not sold any more, so you can buy licenses for 2014 and use them to cover your...
March 9, 2015 at 4:43 am
Very interesting. What worries me is that I could find no documentation about it, just a tiny statement in Paul's post. Such an important information deserves better advertising IMHO
March 9, 2015 at 2:17 am
Viewing 15 posts - 691 through 705 (of 5,394 total)