Forum Replies Created
Viewing 15 posts - 37,351 through 37,365 (of 39,818 total)
-
RE: How do i calculate/compare Query COST (xx%)?
I usually do two things.
1. Measure the time (use select getdate() around the queries) on the server or client.
2. Check the subtree cost. The percentage cost will always be 1...
-
RE: Number of Transaction log backups
Roll with fulls every hour (or every 30 minutes) and then logs every minute or two.
Be sure you get these off the local server in case the server itself fails.
Steve...
-
RE: single qoute
Sorry, I see what you mean.
In the code, the first replace is a single quote, followed by 2 single quotes, then another single quote. Why 4?
1 - open string
2...
-
RE: Number of Transaction log backups
I roll with logs every hour and once a day backups. We may shrink this down. However, it's a question of restore time. How quickly do you want to be...
-
RE: Improving procedure time to complete...
Tough to say. Are teh servers the same hardware? Could be that. Could be fragmented. Might want to check with dbcc showcontig and rebuild clustered indexes.
Steve Jones
-
RE: Sql Questions needed for "new hire" test!
Thanks
.I need to modify this, but the main point still stands. Make someone write some code and use questions that show someone understands SQL, NOT that...
-
RE: single qoute
Each single quote must be doubled for SQL to work a ' repeated as '' is not the same as ". They are two difference characters.
If you replace(@string, '''', '''''')...
-
RE: SQL server Service Manager.
You are welcome and glad to help.
BTW, I usually use a Domain account so I can get to mail, remote backups, etc. Local Admin, not Domain admin.
Steve Jones
-
RE: SQL server Service Manager.
Go into Control Panel, Admin Tools, Services and check the account under which SQL Server runs. It's not the account you log in as.
Steve Jones
-
RE: what happens when you change a table?
Most changes require a rebiuld of the table because the physical structure changes. If you change the table in EM, the third button from the left is a script button....
-
RE: File Groups
yes, you rebuild the index and you can specify the filegroup.
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
note the ON clause.
Steve Jones
-
RE: File Groups
Moving the clustered index should do this. I'd be sure you save the changes, shut down EM and then go back to be sure it refreshes.
Steve Jones
-
RE: SQL Server 2000 & MSDE 2000 on same machine?
Nothing I know of, but I suspect you can do this, but the SQL (rgular) install will be an instance.
Steve Jones
-
RE: SP Security Administration
You will save headaches as Brian mentioned. ALWAYS use roles and groups. NEVER assign individual users.
Steve Jones
-
RE: Programming to run like Profiler?
What do you mean? Run profiler programmatically? This can be done. There are stored procedures to run server side traces.
Steve Jones
.Viewing 15 posts - 37,351 through 37,365 (of 39,818 total)