Viewing 15 posts - 42,796 through 42,810 (of 49,552 total)
Jeff Moden (11/28/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 1:48 pm
rbarryyoung (11/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 12:14 pm
You left out the equals sign in the procedure call. You had that part right last time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 12:13 pm
When you installed SP2, there should have been a utility launch at the end to allow you to specify which windows accounts are sysadmin. On Vista and Server 2008, members...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 10:12 am
Jack Corbett (11/29/2008)
They imply you memorized some canned answered and/or went to boot camp.
There's a frighteningly small percentage that actually studied the material. Not many, but there are some.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:43 am
Well, your procedure (as you posted it) doesn't have any input parameters, hence trying to pass one is going to give an error.
You don't need a variable called @ColumnName, you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:38 am
Jack Corbett (11/29/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:34 am
Ok, that's not of much help. I hate the way the errors are cut off.
See if you can find the job that runs the maint plan. Open the job, find...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:34 am
Jeff Moden (11/29/2008)
GilaMonster (11/29/2008)
Though, if you look, most of those certs are not SQL related...
True enough... but they are suppose to imply the ability to think and do a little...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:29 am
Oksana March (11/29/2008)
Hi Gail,"Stop SQL" you mean stop SQL Server Agent in the Control Panel--Services?
No. I mean stop SQL server. The SQL service must be stopped before you can access...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:28 am
The command I executed to stop the trace:
declare @TraceID int
exec sp_trace_setstatus @TraceID, 0
You need to set the variable to the ID of the trace you're trying to manipulate. There can...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 9:22 am
Jack Corbett (11/22/2008)
GilaMonster (11/22/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:45 am
That's a pretty open question.
On the hardware side, make sure that you have planned for the new users and have capacity. eg if your CPUs are currently running on average...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:20 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic610667-357-1.aspx?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:14 am
You could write the code in notepad and compile with the command-line C# or VB compilers (which are included with the .net framework). It's a lot of work though.
Does anyone...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2008 at 4:13 am
Viewing 15 posts - 42,796 through 42,810 (of 49,552 total)