Viewing 15 posts - 34,366 through 34,380 (of 49,552 total)
I know that MSDE requires a lot more effort to learn than Ms-Access. I am ready to spend whatever the time it requires. I believe you all will guide me.
Start...
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
January 28, 2010 at 7:47 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 28, 2010 at 7:47 am
Leon Orlov-255445 (1/27/2010)
So just out of curiosity... how many database server do you support and how many databases?
Could you please post new questions in a new thread in future, rather...
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
January 28, 2010 at 7:43 am
You're missing the relationship between the table being updated and the subquery. You need to say which row should be updated with which value. That's currently missing.
UPDATE Test SET [CourseName]...
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
January 28, 2010 at 7:40 am
jcrawf02 (1/28/2010)
Have to say, that makes it even harder to understand why SQL Injection is such a problem.
SQL injection happens when a user can inject a value that they pass...
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
January 28, 2010 at 7:35 am
hbujar (1/28/2010)
SELECT @count = COUNT(*)
FROM events e
WHERE e.eventtime>DATEADD(dd ,-1 ,GETDATE())
AND e.eventtime<GETDATE()
...
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
January 28, 2010 at 6:46 am
Where is the BEGIN TRANSACTION?
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
January 28, 2010 at 6:41 am
jcrawf02 (1/28/2010)
... that I'm still just directly concatenating the user input into my SQL.
No you're not. There's no concatenation anywhere in that piece of code. Concatenation means combining a...
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
January 28, 2010 at 6:37 am
Please post new questions in a new thread in future.
How much memory do these servers have? x86 or x64?
What are the symptoms? If you query sys.dm_exec_requests, what are the queries...
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
January 28, 2010 at 1:59 am
mike 57299 (1/27/2010)
How do I get the values from the select statement into vars that can be work with so that I can return a single amount?
What are you trying...
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
January 28, 2010 at 1:55 am
Also maybe worth looking here: http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/
and at these
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
January 28, 2010 at 1:53 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic854934-147-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
January 28, 2010 at 1:51 am
AndrewSQLDBA (1/27/2010)
I did not see anything in the SQL BOL, and I have also looked in the 2008 BOL. I see nothing about this going away.
Exactly. There's no deprecation...
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
January 27, 2010 at 1:11 pm
Then use a server-side trace. It's profiler without the Gui.
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
January 27, 2010 at 1:09 pm
shaunspad (1/27/2010)
Could you explain as it seems they are similar ways to accomplish the same thing.
Because they are two ways to accomplish the same thing.
Pre-SQL 2005, the only database that...
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
January 27, 2010 at 12:57 pm
Viewing 15 posts - 34,366 through 34,380 (of 49,552 total)