Viewing 15 posts - 11,116 through 11,130 (of 22,224 total)
First off, you are using sp_executesql, which is good, as I said. Because of this, you're not generating hundreds & thousands of variations on the query. However, we're still looking...
"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
April 10, 2012 at 9:05 am
Gianluca Sartori (4/10/2012)
Grant, your "Depends" answers made me curious.CLR tricks aside, how can you call a procedure inside a function?
Why can't we use CLR tricks? 😛
And I hope you get...
"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
April 10, 2012 at 8:15 am
I'm not aware of a tool that's going to generate graphical reports on everything you have listed. You might take a look at some of the tools from SQL Sentry....
"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
April 10, 2012 at 8:08 am
mtassin (4/10/2012)
If you choose to use Dynamic SQL, then you need to be warey of injection.
Creating a dynamic SQL string by appending text...
"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
April 10, 2012 at 7:59 am
asranantha (4/9/2012)
2)can we call functionn into another function if yes plz give small...
"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
April 10, 2012 at 7:44 am
Piling on to what Gail said, you need to provide a domain account for SQL Server and give it permissions to that folder.
"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
April 10, 2012 at 4:36 am
dilipd006 (4/9/2012)
Lowell (4/9/2012)
a person with db_owner permissions has the ability to backup, restore, or even drop their own database, i believe.that's very easy to test.
i had already given the db_owner...
"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
April 9, 2012 at 7:52 am
Well, since we're recommending tools, you could check out Red Gate SQL Doc too[/url]. And to get help hooking your database into source control, there's SQL Source Control[/url], also from...
"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
April 9, 2012 at 7:31 am
S_Kumar_S (4/9/2012)
"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
April 9, 2012 at 4:42 am
Similar in concept, but OPENQUERY is like a pass through query. It puts the work on to the remote server.
"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
April 8, 2012 at 8:25 pm
To back that stuff up, you backup MSDB. That's it. That's where that information is stored.
Why would this be hard with different servers? You have backup routines scheduled on all...
"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
April 8, 2012 at 6:17 am
From everything I've read, you'll have to do an uninstall and a reinstall with the different edition.
"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
April 8, 2012 at 6:13 am
Sounds like you're on the right track, especially with adding them to source control. I'd suggest breaking up the storage in source control so that all the objects that belong...
"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
April 8, 2012 at 6:12 am
That's going to bring all of the remote server's data back and then perform filtering on it. Horribly inefficient. Instead, look to OPENQUERY where you can pass some parameters 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
April 8, 2012 at 6:10 am
You're running those in the wrong order. However, the fact that it grew your database means that's how much space your database needs in order to run the rebuild operations....
"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
April 7, 2012 at 5:26 am
Viewing 15 posts - 11,116 through 11,130 (of 22,224 total)