Viewing 15 posts - 9,256 through 9,270 (of 22,224 total)
As you have it currently configured, you're right not to trust it. You're completely open to SQL Injection. For a good laugh, and a good education, see to Bobby Tables[/url]....
"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
December 16, 2013 at 6:33 am
A database backup consists of all the committed pages of the database and enough of the log roll forward or roll back active transactions at the time of the backup....
"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
December 16, 2013 at 6:28 am
You're going to have to go through all the processes of tuning the server, the database and the code. I'd suggest getting a copy of my book on query tuning....
"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
December 16, 2013 at 4:41 am
What version of SQL Server? Is this an Express version? If so, it's probably just not started. You'll have to locate it within the file system to get it started....
"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
December 15, 2013 at 4:51 am
As much as I'd like to say that Red Gate is the way to go, I think you'd be better off using SSIS to build out a migration between the...
"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
December 15, 2013 at 4:49 am
Usually this means you're out of space on the disk.
"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
December 14, 2013 at 5:25 pm
Two options come to mind. First, and possibly not the easiest but certainly the most direct, set up a VPN so that it's part of your network. Second, you can...
"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
December 14, 2013 at 5:24 pm
And I agree with Sean and Jeff too. I didn't look at their answers first. I was just excited by the questions. These are pretty classic types of issues that...
"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
December 14, 2013 at 5:20 pm
hmbtx (12/13/2013)
Question #1:What are the reasons, if any, for this company to seriously consider a SQL Server upgrade from SQL Server 2000?
Media. Make darn sure you have several copies of...
"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
December 14, 2013 at 5:18 pm
tmlink99 (12/13/2013)
It's odd that nodoby here could just say what you do. Grant said to just rely on the integrity of the publication. Is that it?
I did say...
"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
December 14, 2013 at 12:44 pm
I would if I remembered it. It might have been a conversation I had at SQL Saturday DC. I just don't recall, sorry.
"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
December 13, 2013 at 11:05 am
Not a problem. I just like to be clear when I'm posting for one of our products.
It really is one I used to use all the time for the databases...
"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
December 13, 2013 at 8:47 am
Steve Thompson-454462 (12/13/2013)
joe.eager (12/13/2013)
"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
December 13, 2013 at 8:36 am
Great opportunity for a third party product. Red Gate SQL Doc[/url] does this extremely well.
And, disclaimer, I work for Red Gate.
"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
December 13, 2013 at 8:25 am
In addition to what Lowell said, how about identifying where the slow down is from the ASP side of things. I'd suggest looking at a tool like this[/url] to identify...
"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
December 13, 2013 at 7:36 am
Viewing 15 posts - 9,256 through 9,270 (of 22,224 total)