Viewing 15 posts - 48,766 through 48,780 (of 49,552 total)
What distinguishes a dummy course from a real one?
I can give you a query that will find students with a single course, but if they have multiple, there will have...
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
March 15, 2007 at 10:14 am
I read about this on a blog some months back. Can't remember which one. I'm pretty sure it was one of the SQL dev teams.
SQL Server 2005 is under no...
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
March 15, 2007 at 1:45 am
There's no need to create a DTS package just to run a stored proc. A SQL Agent5 job is more than sufficient.
No need to add additional complexity.
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
March 15, 2007 at 12:37 am
What's your question?
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
March 15, 2007 at 12:04 am
Image stores binary data, not text. For storing large amounts of text data use the text or ntext data types.
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
March 14, 2007 at 12:33 am
select suser_sname()
This is assuming they're using windows authentication to connect to the server. If thery're using sql authent, then there's no way I know of to find the windows login.
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
March 13, 2007 at 6:40 am
Don't know about the first or last. The error says there's a syntax error near '-', but there are no dashes in what you've posted.
There's also a syntax error in...
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
March 13, 2007 at 6:38 am
No, I meant a real table. Depending whether you need the variables global across all connections or global across all queries on a single connection you could have aa spid...
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
March 13, 2007 at 2:45 am
A variables table?
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
March 13, 2007 at 12:58 am
The security around the metadata has been changed from 2000 to 2005. Only if a user has some right to an object can they see it in the system views.
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
March 13, 2007 at 12:42 am
Back the database up and restore it to a 2005 server. The db will be converted during the restore. Update all the statistics afterwards, if you can.
You should check afterwards...
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
March 12, 2007 at 2:15 am
Any scheduled jobs that corresond to the slowdowns? Either on SQL or windows scheduled events?
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
March 9, 2007 at 2:01 am
I don't think I need to add serializable isolation as I will want my select statement to see the commited transaction so it doesn't insert a duplicate record.
I'm not sure...
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
March 8, 2007 at 3:41 am
I've before now left profiler running for a full day without issue. Just make sure you apply enough filters to get just what you're interested in (in this case, executions...
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
March 8, 2007 at 2:55 am
Can't you remove the duplicates?
Regarding profiler, can't you leave it runing for some time against the prod database? It would be best to catch the cause of the duplicate calls,...
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
March 8, 2007 at 2:03 am
Viewing 15 posts - 48,766 through 48,780 (of 49,552 total)