Viewing 15 posts - 46,531 through 46,545 (of 49,571 total)
You could run a server-side trace, using the sp_trace* procs. It's very light weight, much lighter than the profiler front end. You can get profiler to script out the trace...
May 19, 2008 at 7:19 am
Make sure you're read this:
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
SQL does not use 1 thread for I/O per data file.
May 19, 2008 at 7:05 am
It could be that you're getting a lock escalation to a table lock. Readpast only goes past page and row locks. A table lock will still block it.
I have no...
May 19, 2008 at 5:39 am
Down in my part of the world, skilled people are leaving for Australia and New Zealand at an ever-increasing rate. 2 friends of mine (both skilled IT people) have left...
May 19, 2008 at 5:29 am
In SQL 2005 the system tables are 'hidden'. You cannot query them or affect them in any way. The SQL parser acts as though they aren't there.
May 19, 2008 at 5:20 am
Is there anything in the windows event log?
If you find the latest error log file, is there anything that indicates a problem?
May 19, 2008 at 5:18 am
What practice exam are you using?
For what it's worth, I didn't see a question that specific on any of the SQL 2005 exams that I've written.
Oh, and just because the...
May 19, 2008 at 5:12 am
Bear in mind that the encryption can't be irreversable. The SQL engine has to be able to decrypt the procedures in order to run them.
2005's better than 2000 was. In...
May 16, 2008 at 7:57 am
It's probably due to the requirement that functions don't have side effects. It's hard to analyse what the CLR proc does to ensure that there is no way it can...
May 16, 2008 at 4:41 am
http://summit2008.sqlpass.org/ - should answer all your questions
It's not in Washington, it's in Seattle
May 16, 2008 at 3:54 am
Have you considered enabling snapshot isolation level?
May 16, 2008 at 2:07 am
Minaz Amin (5/16/2008)
Jeff Please find the Qery text for your ref. Iam waiting for your and Gila's comment for it.
Where?
May 16, 2008 at 2:04 am
The data type of columns in a view will be the data type of the columns in the underlying table, unless there's a CAST/Convert used.
May 16, 2008 at 1:26 am
Yes. very easily. It's not actually encryption, despite the name. It's kinda hashed and hidden.
There are a number of tools on the net to decrypt procs. A quick google search...
May 16, 2008 at 1:23 am
Viewing 15 posts - 46,531 through 46,545 (of 49,571 total)