Viewing 15 posts - 13,636 through 13,650 (of 22,227 total)
Uninstall would be through your control panel. You should be able to do that if you have adequate privileges on the machine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 12, 2011 at 4:56 am
the only way to understand what could happen is to test it. I've set up tests where I ran a set of procs against a database at 1x, 10x, 100x...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 12, 2011 at 4:53 am
You're also only going to be able to shrink as far as you have space available. Unless you created an 800gb database and only put 400gb of data in it,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 12, 2011 at 4:46 am
I'm fairly certain that would have stopped execution of the maintenance plan. But the best thing to do is check. Have you run the maintenance plan before? How long did...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 12, 2011 at 4:23 am
Ramón Ontiveros (1/11/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 12, 2011 at 4:09 am
Is the slow down because of the INSERT itself?
If not, I'd say check the execution plan. If it's the same as the one you get when you run the function...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 12:57 pm
Darryll Petrancuri (1/11/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 12:40 pm
No. Not really. This is psuedo-code to describe the situation:
WITH MyCTE(...)
INSERT INTO MyTable
SELECT * FROM MyCTE AS x
JOIN MyCTE as y
ON x.ID = Y.ID
and x.Type=1
JOIN MyCTE AS z
ON x.ID =...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 12:38 pm
peleg (1/11/2011)
"SSC Veteran" - what do you mean by that?that you can't use the same cte more then once in one session?
Yep. A CTE can be referenced multiple times inside...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 12:26 pm
JEFFREY SCHELL (1/11/2011)
- Let's say we have a Thing table which has two columns ThingID and ThingTypeID. ThingID...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 11:06 am
I would not pick a varchar as my first choice for a clustered index... or my second. SSN's are not like GUID's because there is a structure to SSN. It's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 11:02 am
You can take a look at sys.dm_db_session_space_usage or sys.dm_db_task_space_usage. They might give you indications.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 10:59 am
Henk de W (1/11/2011)
to be honest, it doesn't seem to make much senseConversion failed when converting the varchar value '13-10-10 21:00:00 ' to data type int.
Ah, I'll bet postcode has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 9:49 am
WayneS (1/11/2011)
Might I suggest two things:
1. First, do not add things to master. Instead, create a database (named something like "Common"), and put all your special stuff there. Yes, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 9:40 am
What's the error that you're getting?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2011 at 9:25 am
Viewing 15 posts - 13,636 through 13,650 (of 22,227 total)