Viewing 15 posts - 12,691 through 12,705 (of 22,214 total)
Ah, you'll have to build out a rather large script that can go into a given backup and get the file structure out and then automatically figure out where to...
April 20, 2011 at 10:00 am
On this one, I'd get in touch with Microsoft. That sounds like you've run into something serious.
April 20, 2011 at 6:48 am
Koen Verbeeck (4/20/2011)
I haven't really used it before (but I'm the only BI guy available in the...
April 20, 2011 at 5:59 am
Nope, a plan guide won't help. Temporary tables have statistics. As the data changes, statistics get updated. When statistics updates meets certain thresholds, you get recompile events firing. If the...
April 20, 2011 at 5:01 am
I would not use affinity unless you've already identified a need to share resources with some other service. Just leave it alone.
I would also leave the max degree of parallelism...
April 20, 2011 at 4:58 am
It's impossible to suggest anything to you without more information. The execution plan and a complete table structure are the minimum we need to begin to make even somewhat intelligent...
April 20, 2011 at 4:55 am
Take a look at sys.dm_exec_requests and sys.dm_os_waiting_tasks and you can tell exactly what the process is waiting on and if it's blocked.
April 20, 2011 at 4:54 am
It's just a standard RESTORE operation using the REPLACE keyword, probably along with MOVE. Look it up in Books Online. There are even examples of how to replace a database...
April 20, 2011 at 4:52 am
There isn't one single way of doing this, but in general, it would be the DBA responsible for the rollout. To really get into deployments in detail, I'd suggest getting...
April 20, 2011 at 4:51 am
You can try using ping to see if you can at least get to the server. There's also a utility for download somewhere called sqlping that's a bit more specific.
April 20, 2011 at 4:48 am
Oh, I think I see. The formatting was WAY off there.
Take a look at the command GROUP BY. You can perform aggregate operations on your data using that. SUM() would...
April 19, 2011 at 6:16 am
Is the problem the server or certain queries. If it's the server, you need to focus on server settings and configurations. Min/max memory, parallelism, cost thresholds, cpu affinity, all that...
April 19, 2011 at 5:25 am
Indications are, you may have different versions of SQL Server on your client machine and on your server. I'd check that first. You should be able to load SMO. That's...
April 19, 2011 at 5:23 am
The first thing I would do is see what a select statement with this as the WHERE clause looks like:
WHERE CO='01' AND BRANCHID<>'CLNT'
What kind of execution plan are you getting?...
April 19, 2011 at 5:18 am
I'm confused, based on the data provided, how does RAJ get a value of 800? What is it that you're trying to do?
April 19, 2011 at 5:16 am
Viewing 15 posts - 12,691 through 12,705 (of 22,214 total)