Forum Replies Created
Viewing 15 posts - 1 through 15 (of 22 total)
-
RE: Two Things
Hi!
Correction: we ARE from Europe! 😉
While I'm at it, some of those who almost made it in our list: Martin Luther King Jr., Pablo Picasso, John F. Kennedy, Che Guevara (more for the...
-
RE: Two Things
Hi all!
We are not from Europe, let us see what my wife and I can do. 😉
. Marie Curie
Women seriously lack in your list (apart from Mother Teresa), gentlemen! 😉
So Marie Curie...
-
RE: Difference between creating a single index on two columns and creating two seperate indexes on those two columns
Hi!
Let us work with an example:
---
use tempdb
GO
create table threecol (
uid int identity primary key,
val1 int,
val2 int)
GO
create index idxval1 on threecol (val1)
GO
create index idxval2 on threecol (val2)
GO
declare...
-
RE: An aggregate may not appear in the set list of an UPDATE statement????
Hi!
What about doing the aggregate first in a temp table?
-- untested code! Just to give you the idea!
select JOBID, COUNT (JOBID) as cnt
into #temp
August 30, 2005 at 2:15 am
-
RE: Deadlocks Involving Locks
Hi!
Your deadlock is clearly between dbcc shrinkdatabase and vanX_callhistory; no other background process is involved.
A special situation is needed for a conflict to arise, it will not necessary...
-
RE: Deadlocks Involving Locks
Hi!
You have two competing transactions, their Input Buffers being:
1. DBCC SHRINKDATABASE ('in_cdr') [SPID 56]
2. vanX_callhistory '667786', '08/01/2005', '8/22/2005', 'SCRATCH','Pross','23.0.80.10' [SPID 52]
It seems like both transactions are trying to convert an intent-read...
-
RE: Transaction Handling
Hi!
Actually, things are written in your SP_Status table, but this latter is locked and you cannot read it from another transaction until the writing one is committed. This is the...
-
RE: SQL server db implemetation guidelines
Hi!
I know of this:
http://www.sql-server-performance.com/vk_sql_best_practices.asp
It is not what you need, but it contains one billion good ideas.
As for "pure" coding conventions (such as how to write identifiers or how to...
-
RE: Made a big mistake
Hi!
Although not a software, the NSA published a guide on how to secure SQL Server:
http://www.nsa.gov/snac/downloads_msql.cfm?MenuID=scg10.3.1.2
BTW, they also publish guide on securing Windows (because a hardened SQL Server on a...
-
RE: SQL server db implemetation guidelines
Hi!
I do not have a doc at hand, but you certainly can build something out of the examples contained in the Books Online (Start > Programs > Microsoft SQL Server...
-
RE: Audit logs
Hi!
You can also use the sp_trace_* stored procedures, which enable you to do with T-SQL what the profiler does. They need a bit of practice, though.
Bye,
Xavier
-
RE: Performance " IS Not Null" vs "Not IS Null"
Hi!
Well, I performed the following tests (SQL2K SP3):
---
USE Northwind
GO
select ShipRegion from Orders
where ShipRegion IS NOT NULL
select ShipRegion from Orders
where NOT (ShipRegion IS NULL)
---
Auditing with the profiler gives (show plan statistics):
-...
-
RE: Tips for Optimizing Data Manipulation Language
Hi!
Thanks for this worthy article.
I have a question about it: the author states that TRUNCATE TABLE "invalidates the transaction log". I'm certainly missing the point here; indeed, TRUNCATE TABLE is...
-
RE: Reference tables and performance
Hi all!
Aaron, thanks for your trick for solution (ii), I will test that tomorrow first thing (Hey, I'm back home now
).David, thanks for...
Viewing 15 posts - 1 through 15 (of 22 total)