I am confused...[B)]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade...
And, we don't have a maintenance plan on the db yet, that runs regularly
WHat is BOL?
Our DBA has this question:
When we set the Recovery Model to "Full" for the msdb database in SQL Server 2000..
After a reboot it sets the Recovery...
"Inserting an Image into a Column"
Are the requests only reads?
Do they write to the db too?
quote:Originally posted by Argyle
Server side cursors are a pain when it comes to...
cursors are really slow..
Looks like Dimi's idea is the way to go
This is what I tried:
INDEX: NON-Clustered on Person_id (PK)...
You can use the EM to create and run 'Maintenance plans'
Right click on the db in EM. All tasks > Maintenance plan
It brings up an easy to use...
But you can create a non-clustered index
quote:Originally posted by ramesh
I think we can create only ONE clustered index for a table.
bambola is right. Doing an insert in the lastpage is the best option.
Minimizing trips to the database will make the pages load faster.
For the drop down list to have a dynamic list of over 2000 names in it:<br />1. Transport to client browser should be real slow<br />2. Retrival from...
[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />I 've actually tested it using an account I registered:...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />I have been frequenting this site these days and I think it is great.<br /><br...
Just out of curiosity:
If you are only adding rows to the table..
why do you actually have two more non-clustered indexes?
As I see it:
So, am I right in saying a View is totally free.. in terms of performance
in other words, it adds nothing to the performance load
or using a view...
select count(*) from someTable
select count(ID) from someTable
wouldn't the second one be way faster than the first?
I have read in one of the posts that use Select * is inefficient..
I was wondering what the experts' opinion would be...[8D]
You see, when we do...
<br />What exactly are these stored proc dt_*<br />eg<img src='/community/emoticons/emotion-2.gif' alt=':d' />t_getpropertiesbyid_vcs_u<br />...
I got it work.
I just copied the files again and did not move them around like I did last time!
Sunny Kanaparthy is a...
What I am actually trying to do is this:
WE have a perfectly running db on server1
I detached it and copied the files to a server2
Separate names with a comma.