Viewing 15 posts - 7,141 through 7,155 (of 22,213 total)
Using the GUI all the time with SQL Server 2014. It works just fine. Plenty of resources for learning it too.
December 4, 2014 at 8:46 am
But now, it's just going to grow again. And while it grows, it's going to cause other processes to slow down and wait for that file growth. You're only temporarily...
December 4, 2014 at 8:11 am
Not even a good guess. Now, frankly, I'm curious. I'm with Steve. Set this one fire and move on... after you capture the wait stats.
December 4, 2014 at 7:57 am
December 4, 2014 at 7:48 am
yeah, if you want to explore multi-server management, you certainly can schedule them to run across multiple servers.
December 4, 2014 at 7:46 am
Weird.
I tried to replicate it. Standard worked just as fast as Enterprise on the VM I created.
Have you tried capturing wait stats before and after running the create database command?
December 4, 2014 at 7:18 am
Yeah. It'll generate a script, or you can generate a report of the differences, or both. All from the command line. I forget the syntax, but it's in the documentation.
December 4, 2014 at 5:02 am
OK. I'm back.
I spun up an Enterprise server taking all the defaults and then created a database. It only took about 3 seconds (if that). Maybe this is on Standard?...
December 4, 2014 at 4:46 am
And because you're selecting everything, that's all stored with the clustered index, hence the scan.
How many rows is it returning out of how many rows in the database?
December 4, 2014 at 4:17 am
Check the wait stats before and after the query runs on the slow machine to understand what is causing it to slow down. Also, compare the execution plans between the...
December 4, 2014 at 4:15 am
I know I work for Red Gate now, but, prior to working for Red Gate, I had SQL Compare open on my desk pretty much every day. Plus, you can...
December 4, 2014 at 4:13 am
Instead of using a linked server, what about using OPENQUERY?
December 4, 2014 at 4:06 am
That's a weird one. And it's Enterprise that's causing the problem?
I haven't seen it, but I'll go spin up a VM and see what happens.
December 4, 2014 at 4:02 am
I prefer using OPENQUERY to linked servers so that I can pass parameters to the linked machine in order for it to do as much filtering of data as possible...
December 4, 2014 at 4:00 am
But, if it's a data warehouse, does it need to have point in time recovery? If not, maybe Simple would work for you.
You'll still need to set the transaction...
December 4, 2014 at 3:57 am
Viewing 15 posts - 7,141 through 7,155 (of 22,213 total)