Viewing 15 posts - 691 through 705 (of 5,393 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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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.
-- Gianluca Sartori
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',
...
-- Gianluca Sartori
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
-- Gianluca Sartori
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)
-- Gianluca Sartori
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
-- Gianluca Sartori
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...
-- Gianluca Sartori
March 10, 2015 at 10:33 am
I might add that setting up QoS helped us a lot.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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 🙂
-- Gianluca Sartori
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...
-- Gianluca Sartori
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
...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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
-- Gianluca Sartori
March 9, 2015 at 2:17 am
Viewing 15 posts - 691 through 705 (of 5,393 total)