I another thing is that instead of complaining about wrong answers to QotD and demanding points back because the answer(s) were wrong (as in this case) or the question was...

Hows this:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

sum(isnull(ScoreCard.Finished,0)) as Wins

from

dbo.Player

...

Yes, it is a SQL injection attack.

I'd notify the the 3rd party provider of the web application regarding the SQL Injection attack. If it is getting through to your...

Not real sure what you are asking for here. Can you provide a more detailed example of what you are looking for?

😎

Option 2 takes out one of the tables (Event). Not sure what the difference in IO's, execution plans, overall performance on a full production system.

😎

And just for the heck of it, here is more (slightly formatted):

DECLARE @T VARCHAR(255),

@C VARCHAR(255)

DECLARE Table_Cursor CURSOR

FOR...

Here is a second option:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

sum(isnull(ScoreCard.Finished,0)) as Wins

from

...

Got to plug HyperBac. We have installed it on 7 servers so far (it is also licensed per server) and it has reduced backup/restore times on these servers as...

How does this look:

with PlayerWins (

PlayerID,

Wins

) as (

select

Player.PlayerID,

sum(isnull(ScoreCard.Finished,0)) as Wins

from

dbo.Player

...

Based on the sample data, what is the expected output? Need something to check our work against.

😎

Well, we need more info before we can really help. Besides seeing the code for you stored procedure, we also need to see the DDL (create statements) for your...

It could be less. If you are looking at the size of the mdf/ldf's, then you are seeing how much physical space the files are taking on the OS....

TheSQLGuru (6/19/2008)

---

My advice is to never use DTA at all!! I have seen it do AWFUL things to databases. Well, actually that works in my favor since I...

You are almost there. Just need some sample data (in the form of insert statements so we can cut, paste, and execute), and what the expected output would be...

Not sure. I never had a reason to log HTTP (Web requests). You'll have to research that one on your own.

😎