Viewing 15 posts - 1 through 15 (of 18 total)
>> in the last few weeks
I suppose it started with installing SP4. Ask your DBA.
Under my observations, the first difference between SP3 and SP4 is the way how SQLServer displays processes...
August 11, 2005 at 4:41 am
"With encryption" - easy decrypting by dSQLRVD.
>>I was thinking of putting the desired SPs and UDFs in another DB on the same server where the main DB owner has...
August 11, 2005 at 4:24 am
I think your way is trace with events : Stored Procedures->SP:StmtCompleted, TSQL->SP:StmtCompleted.
August 11, 2005 at 4:15 am
C2 Audit is not for such tasks as q
August 11, 2005 at 4:12 am
>>Anyone know a way to tell when the database size is automatically expanding?
Start Profiler, add events Database->Data File Auto Grow, Database-> Log File Auto Grow
Wanna sheduling - script...
August 11, 2005 at 4:06 am
Notice that BuyListingID 2 does not join to SellListingID 10 because it is already used in the result set. Also, BuyListingID 3 does not join to SellListingID 10 or 11,...
September 24, 2004 at 4:31 am
>>I have no idea why, but the cursor is faster.
I have idea
Look at master.dbo.sp_MsForeachtable - and you will find cursor.
It is not astonishing...
September 22, 2004 at 4:26 am
How do I check equality of tables:
1. Simplest. COUNT(*) AND UNION
Count1 = (SELECT COUNT(*) FROM Server1.db1.dbo.Table1)
,Count2 = (SELECT COUNT(*) FROM Server2.db2.dbo.Table2)
,CountUnion = (
SELECT COUNT(*) FROM
September 22, 2004 at 3:56 am
With XP you have to use temp table, you cannot use table variable.
September 22, 2004 at 2:51 am
You have to write a program using DMO.
If you do not want to write - look here: http://www.sqlservercentral.com/scripts/contributions/1151.asp
It's your part B and even more.
September 21, 2004 at 8:10 am
With SP you have to use temporary table. With XP also.
SP you can rewrite into UDF, XP - no way.
September 21, 2004 at 3:43 am
Try something like this:
@timeout = 300
DECLARE ACur CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
DATEDIFF(s, last_batch, getdate()) > @Timeout
AND spid> 25
September 10, 2004 at 3:28 am
"Readers block writers"
Try SELECT * FROM ATable (TABLOCKX) and you lock your server forever.
You can write near each table (NOLOCK) or better write SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on...
September 10, 2004 at 3:09 am
I've also saw such "magic numbers". On different systems and different tables it was each time different.
ROWCOUNT is not recommended in BOL, isn't it?
TOP looks preferable.
June 25, 2004 at 3:23 am
>>Error = [Microsoft][ODBC SQL Server Driver]>>String data, right truncation
SQL Server tells you that your table contains a string field that have lesser length than in your format file.
Check your table...
June 25, 2004 at 3:17 am