Viewing 15 posts - 47,626 through 47,640 (of 49,552 total)
Yes. There's another post active at the moment on exactly this issue.
If you don't prefix the table you risk double lookups for SQL to find the table and you also...
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 18, 2008 at 11:48 am
Brandie Tarvin (1/10/2008) Lastly, I can't remember if I heard the Dev exams are harder or easier than the Upgrade Admin cert. Thoughts on this? Or is it...
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 18, 2008 at 11:36 am
Brain dumps are nothing more than cheating. Using (or passing on) brain dumps can get you your MS certifications revoked, permanently.
The MS links I gave earlier list the courses and...
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 18, 2008 at 11:25 am
No. All this is doing is dropping a bunch of tables, procedures and functions if they exist.
To stop a trace requires the sp_trace_setstatus proc to be called. (Assuming that we...
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 18, 2008 at 11:15 am
Compile by running them?
By recreating them?
By calling sp_recompile (Which actually does nothing other than mark the execution plan to be recompiled on next run) ?
Some other way?
What happens...
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 18, 2008 at 12:15 am
What do you mean by 'become invalid'?
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 17, 2008 at 11:58 pm
The first one usually means that there's a syntax error in the statement that you're sending to the remote server.
Thse second one is because the SQL server that you're running...
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 17, 2008 at 5:38 am
It's a property of logarithms.
Edit: My maths stinks. So out of practice.
e(ln(x) + ln(y)) = x * y for all values of x and y
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 17, 2008 at 5:16 am
Look up Pivot in Books online. I think it may do what you want.
Also, take a look at this article. It's not completely clear which columns are which in your...
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 17, 2008 at 5:15 am
How ae you loading the data? If you're using a bulk load (bcp, Bulk insert) then put the DB into bulk-logged recovery.
In that mode, bulk operations are minimally logged and...
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 17, 2008 at 5:13 am
avipenina (1/17/2008)
are you sure that rebuild index do what update statics and reorganized index do?
Very sure. If I wasn't sure, I wouldn't have said so. But, feel free to check...
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 17, 2008 at 2:42 am
I'm not sure what DEcode does. From what you said, perhaps REPLACE?
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 17, 2008 at 12:25 am
Firstly, I will suggest that you read Books Online (SQL help file) as there's a lot of very good info in there.
Foreign keys are used to enforce referential integrity between...
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 17, 2008 at 12:21 am
Blocking will eventually resolve itself. A deadlock, however, will never clear up by itself. That's why SQL Server has a deadlock monitor that, when it finds a deadlock, will roll...
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 16, 2008 at 11:53 pm
Jenny Zhou (1/16/2008)
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 16, 2008 at 11:26 pm
Viewing 15 posts - 47,626 through 47,640 (of 49,552 total)