Viewing 15 posts - 46,516 through 46,530 (of 49,552 total)
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.
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
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?
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
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...
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
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...
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
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...
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
May 16, 2008 at 4:41 am
Enought that reaching the limit indicates a serious problem in your database design.
The exact number's in Books Online. I think it's 256.
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
May 16, 2008 at 4:35 am
http://summit2008.sqlpass.org/ - should answer all your questions
It's not in Washington, it's in Seattle
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
May 16, 2008 at 3:54 am
Have you considered enabling snapshot isolation level?
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
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?
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
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.
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
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...
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
May 16, 2008 at 1:23 am
Unless you have some form of auditing enabled, or traces running, that kind of info's not stored.
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
May 16, 2008 at 1:13 am
Wed-fri. Mon and tues are usually Pre-conference days.
The friday is sometimes slower than the other 2 days. I wouldn't say it's worth missing though.
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
May 16, 2008 at 12:54 am
One place I've used a time where I didn't want a date was in job monitoring. I have the latest time that a job may be completed before alerts get...
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
May 16, 2008 at 12:20 am
What were they?
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
May 16, 2008 at 12:13 am
Viewing 15 posts - 46,516 through 46,530 (of 49,552 total)