Viewing 15 posts - 1,201 through 1,215 (of 7,168 total)
Ok, sounds like Agent is not an option. There are others shown in the article I linked to.
April 29, 2013 at 9:04 am
tony28 (4/28/2013)
opc.three (4/27/2013)
tony28 (4/26/2013)
I used OPTION(RECOMPILE) and it is ok, but without is wrong,,,---- and in milisecond is little worst, but better than before.
It has to do with how a...
April 29, 2013 at 8:01 am
Ok, that confirms that the person owns the database. Chances are they created the database initially since SQL Server will make the database creator the database owner and many people...
April 29, 2013 at 7:47 am
tony28 (4/26/2013)
I used OPTION(RECOMPILE) and it is ok, but without is wrong,,,---- and in milisecond is little worst, but better than before.
It has to do with how a plan is...
April 27, 2013 at 9:18 am
Sergiy (4/27/2013)
opc.three (4/26/2013)
For a database that does not need point in time recovery,Which means - can afford to lose data.
Which is not the case by default.
Agreed. If you reread...
April 27, 2013 at 8:28 am
I could not care less what Sergiy says about anything and do not need a translator of his thoughts. I actually think its odd that you continue to do that....
April 26, 2013 at 10:49 pm
For a database that does not need point in time recovery, yes, I would recommend changing to Simple recovery mode.
Try to keep it professional Sergiy.
April 26, 2013 at 10:44 pm
You forgot to supply a WHERE clause in the query that uses the VIEW. You need a predicate that folters on the column where your check constraint is:
SELECT * FROM...
April 26, 2013 at 4:43 pm
Sergiy (4/25/2013)
FULL backup takes care only about data pages from data files.It does not touch TRN log file at all.
That's not entirely accurate. You are right in that when in...
April 26, 2013 at 4:21 pm
Tony414 (4/23/2013)
First off I am new to this forum and don't know much about sql. I guess that's why I am here 🙂 I hope I am in the right...
April 26, 2013 at 1:20 pm
Best I can tell from some basic testing on this side, changing the database owner does not require exclusive access to the database.
When you run the command, look at the...
April 26, 2013 at 1:10 pm
A proper solution would be to get rid of the use of xp_cmdshell all together.
The recommended way using either a SQL Agent job or a web service that invokes...
April 26, 2013 at 12:59 pm
ankur_libra (4/26/2013)
As per below link article:-
http://support.microsoft.com/kb/970070
Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems was made available from
"Cumulative update package 4 for SQL Server 2005 Service...
April 26, 2013 at 12:09 pm
It might be the UI design causing confusion, or being plain wrong.
What does this say?
USE YourDatabaseName;
GO
SELECT sp.name
FROM sys.database_principals dp
...
April 26, 2013 at 11:46 am
Sergiy (4/26/2013)
opc.three (4/26/2013)
PowerShell has security scaffolding in place
You might be surprised - but SQL Server has it too.
And cowboy developers may (most certainly will) ignore that scaffolding in PowerShell as...
April 26, 2013 at 10:32 am
Viewing 15 posts - 1,201 through 1,215 (of 7,168 total)