Viewing 15 posts - 4,921 through 4,935 (of 7,168 total)
You could try some slight-of-hand. Restore the DB, then change your DB-context to the new DB and immediately set it to SINGLE_USER mode. This will lock everyone else out except...
March 13, 2012 at 1:37 pm
No. For msdb, model and tempdb issue ALTER DATABASE...MODIFY FILE to set them to the new location, shut down the instance, move the files (except tempdb, just delete files), then...
March 13, 2012 at 1:00 pm
How about something like this?
IF OBJECT_ID(N'tempdb..#SSISLogging') IS NOT NULL
DROP TABLE #SSISLogging;
DECLARE @ImportPackage VARCHAR(160),
@ImportPackageString VARCHAR(170),
@ImportPackageStatus INT,
...
March 13, 2012 at 12:44 pm
Sounds good, happy to assist! Just to drive the point home about connection pooling...any difference between two connection strings will cause them to be viewed as different connections by your...
March 13, 2012 at 12:32 pm
Purely using T-SQL? You would need to use xp_CmdShell and pipe the output into a table :sick:
You could look at the option Koen provided, and I'll add one more to...
March 13, 2012 at 10:37 am
Sean, you beat me to it on the Application Name post by 4 minutes! Tsk tsk on the use of sys.sysprocesses here 😉
March 13, 2012 at 9:24 am
Option 1: Use Windows Authentication.
You're describing the whole premise behind Windows Authentication! ...why are we using SQL Logins? Is this for a public-facing web app or an app with many...
March 13, 2012 at 9:22 am
SQL Server 2008 and SQL Server 2008 R2 both offer the same maximum compatibility level, 100, so T-SQL that runs on SQL 2008 will have no issue running on SQL...
March 12, 2012 at 8:36 pm
If you setup a trace to capture the SQL:BatchCompleted event with the TextData column and add a filter on only the login name, i.e. do not add a filter on...
March 12, 2012 at 4:01 pm
You can change the max memory setting and it takes effect without requiring a restart. Here is a good guide on what to set it to:
March 12, 2012 at 12:40 pm
Eugene Elutin (3/12/2012)
opc.three (3/12/2012)
...
Table '#test_objects'. Scan count 1, logical reads 1174, physical reads 0, read-ahead reads 0,
lob logical reads 0, lob physical reads 0, lob...
March 12, 2012 at 9:36 am
Eugene Elutin (3/12/2012)
opc.three (3/9/2012)
Re: "you should try to make trigger as lightweight as possible"
I could not agree more, Eugene. Unfortunately your example will force a full scan of the...
March 12, 2012 at 9:10 am
george sibbald (3/10/2012)
opc.three (3/10/2012)
george sibbald (3/7/2012)
March 10, 2012 at 2:38 pm
I also failed to mention that the original symptom I was seeing that led me to go down the path of adding the 3GB switch and setting up LPIM was...
March 10, 2012 at 8:21 am
Note: my comments pertain to 32-SQL Server Standard Edition running on 32-bit Server 2003 R2 with 4GB physical RAM and the /3GB switch enabled.
george sibbald (3/7/2012)
March 10, 2012 at 6:50 am
Viewing 15 posts - 4,921 through 4,935 (of 7,168 total)