Viewing 15 posts - 811 through 825 (of 1,583 total)
Are you positive you are a member of the local administrators group on your machine?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2013 at 1:19 pm
Yes, it is needed. It's basically a "tempdb" for SSRS. It's basically used to store snapshots of data while reports run.
I have to ask, "why" do they want...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2013 at 9:23 am
Our tempdb-database is configured having 8 data files. As Microsoft recommends we have one data file for each core, all having same file size and grow rate.
They also recommend sizing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2013 at 6:45 am
The TSQL I posted above will work for this, simple tweak here and there...just add in a join to sysjobhistory for cases where you are checking for something in the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 24, 2013 at 6:41 am
This is the best stab I can take at it, perhaps Lynn can drum up a much nicer approach 🙂
Main Scalar FunctionALTER FUNCTION dbo.fx_GetAliasID (
@Table sysname, @Value varchar(6)
)
RETURNS varchar(500) AS
BEGIN
DECLARE...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 11:08 pm
In SQL 2005 & 2008, Under SQL Profiler Options there should be a radio button under "File Rollover Options" to say "Prompt before loading rollover files". And yes, there...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 7:40 pm
I am confused and perhaps just missing the obvious. You just want to return the column name for the column that's the PK in any given table? DECLARE @Table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 7:34 pm
These links may help - http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/5c79be1c-f450-4c81-9112-d529c6f04fac/
And - http://www.sqlservercentral.com/Forums/Topic937282-1549-1.aspx#bm938750
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 12:35 pm
Since you want to check the current status of the job, I'd use sysjobactivity. Perhaps something like this?
WHILE (
(SELECT TOP 1 ISNULL(last_executed_step_id, 0)
FROM msdb.dbo.sysjobactivity
WHERE job_id = 'UID'
ORDER BY...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 11:14 am
Try something like this:CREATE TABLE #test (servicedate date, eligdate date)
INSERT INTO #test
SELECT '8/6/2012', '8/4/2012' U-N-I-O-N ALL
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 10:20 am
I know this sounds weird, but try setting the classifier function = NULL beforehand, then assign it
ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = NULL);
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO
Then run:ALTER RESOURCE GOVERNOR WITH...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 9:40 am
Shen1 (1/23/2013)
"We are experiencing long delays
1. Check the latency for the subscription/publication in the replication monitor, 2. Check for errors, 3) How many undistributed commands do you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 23, 2013 at 8:49 am
Definitely test, then test some more 😉 Increasing the volume of the data in the batch will have it's own overheard on your transaction log.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:55 pm
Beat to the punch on this one 😀
Dwain has made some very valid points!
@Dwain, are you referring to CDC (Change Data Capture)?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:47 pm
You have 2 options, forgive my quick code but wanted to throw something together that would work for you (I tested it locally just fine) - hope this helps!
1) Re-execute...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 22, 2013 at 9:46 pm
Viewing 15 posts - 811 through 825 (of 1,583 total)