Viewing 15 posts - 47,071 through 47,085 (of 49,571 total)
From what you've said, I would not suggest you consider a degree at the moment.
For the record, I have a B.SC and I'm currently studying for my M.Sc. so...
March 30, 2008 at 12:03 pm
Maybe.
How many rows are in the table? What are the indexes on the table?
If there are no indexes, sql will do a table scan to find your rows. That means...
March 29, 2008 at 1:12 pm
You can't restore a 2005 database onto a 2000 server. There's no downgrade option.
To install the DB engine, you need to get hold of the full 2005 installation.
What did you...
March 29, 2008 at 12:54 pm
Depends.
If you're doing something like this, all will be rolled back
Begin transaction
set xact_abort on
update ...
update ....
update ....
commit transaction
If each update is within its own transaction (or if you're not explicitly...
March 29, 2008 at 12:52 pm
You need the /pae switch (to enable AWE memory at the OS level), but you do not want the /3GB switch (which limits the kernel to only 1 GB of...
March 29, 2008 at 12:49 pm
For next time it happens (or for anyone else reading)
Detach the database. Move the transaction log to a drive that does have some space. Reattach the database. You can't backup...
March 29, 2008 at 12:40 pm
I'm still curious what you're doing with these created tables. Are the sales people selecting from them (and if so, can you change the queries they use)? Are you exporting...
March 29, 2008 at 12:35 pm
One change in SQL 2005 is that profiler records durations in microseconds, not milliseconds like 2000 did.
By default the gui still shows in milliseconds, but behind the scenes (for filters...
March 28, 2008 at 6:59 am
For something this simple, CLR will probably be comparable or slower, but do test for yourself. Where CLR shines is for really complex regex functions
March 28, 2008 at 6:54 am
MissN (3/28/2008)
March 28, 2008 at 6:37 am
Are you doing this to learn CLR? If not, you can create exactly the same proc in T-SQL using the REPLACE command
March 28, 2008 at 6:29 am
It's not new 2005 features, but the Update ... FROM will probably help here.
update MyTable
set MyTable.SumValue1= SumOfValue1,
MyTable.SumValue2= SumOfValue2
FROM
(SELECT...
March 28, 2008 at 3:57 am
Could you be a little more specific please? What kind of threats are you thinking about?
March 28, 2008 at 2:51 am
Ignacio A. Salom Rangel (3/27/2008)
GilaMonster (3/27/2008)
You may also want to run perfmon during one of these slow downs, see if any counters are wildly different from...
March 28, 2008 at 1:57 am
webrunner (3/27/2008)
OK, thanks! Database A (the one at the 80 level) is a SQL 2000 database that was restored onto SQL 2005,
Make sure that you update the statistics. The...
March 27, 2008 at 3:18 pm
Viewing 15 posts - 47,071 through 47,085 (of 49,571 total)