Viewing 15 posts - 39,616 through 39,630 (of 49,571 total)
mithun.gite (4/21/2009)
GilaMonster (4/21/2009)
mithun.gite (4/21/2009)
Can any one give me a link for Query Optimization, using that i can start optimizing my queries?
I can suggest some books.
Inside SQL Server 2005: Query Tuning...
April 21, 2009 at 6:44 am
DKG (4/21/2009)
Gail , MANU this scirpt doesn't work for sql 2000
No, it won't. The question's in the 2005 forums, hence the query posted uses 2005 features.
If this is for SQL...
April 21, 2009 at 6:35 am
David O'Reilly (4/21/2009)
how does SQL know when to create these backups?
SQL doesn't take automatic backups. A database is backed up when a BACKUP DATABASE statement is run, either manually or...
April 21, 2009 at 6:31 am
r.hensbergen (4/21/2009)
Avoid using (NOT) IN (SELECT...), use joins or EXISTS instead.
Not necessarily. As with many things, the best advice here is test and see which, if either, is faster.
Avoid...
April 21, 2009 at 5:50 am
David O'Reilly (4/21/2009)
Looking again at the MSDB database, there was a full database backup created this morning. How do i found out where these backups are?
This morning's not going to...
April 21, 2009 at 5:48 am
mithun.gite (4/21/2009)
Can any one give me a link for Query Optimization, using that i can start optimizing my queries?
I can suggest some books.
Inside SQL Server 2005: Query Tuning and Optimisation
SQL...
April 21, 2009 at 5:30 am
brd123 (4/21/2009)
(what the heck is wrong with this forum..this is the 3rd time i have tried to post this)
Seeing as it's posted 3 times, I'd say absolutely nothing.... 😀
April 21, 2009 at 5:28 am
No backup = no data. Simple as that. There is no way you're going to restore data lost several days ago if you have no backup.
Are you sure there's absolutely...
April 21, 2009 at 5:26 am
TECHBABU (4/21/2009)
- If the disk space is full due .ldf
detach the database and add new...
April 21, 2009 at 5:21 am
What does the SQL error log say? There will be a much more detailed error there. Please check the error log and post any errors relating to database Common.
This is...
April 21, 2009 at 5:19 am
AShehzad (4/21/2009)
Also you may analyze the SQL Server recommendations about missing indexes http://blog.dbdigger.com/2009/04/get-information-about-missing-indexes.html
Just bear in mind that the missing index info is a suggestion. It's not always the best index,...
April 21, 2009 at 4:57 am
Firstly this is a problem
If Exists(Select Name from tempdb.sys.objects Where Name like '#Export%' and type = 'U')
Begin
Drop Table #Export
End
That exists will find any instance of that table, even one that...
April 21, 2009 at 4:57 am
Helical Johan (9/11/2008)
hi...how can i convert a timestamp field to varchar?
thanks....
Why do you need the timestamp column as a varchar? Despite it's name, timestamp has absolutely nothing to do with...
April 21, 2009 at 4:44 am
Noman Tariq (4/21/2009)
Do i create seperate 10 indexes on every column? is it a good approach?
That's only really useful if you have queries that filter on only one column at...
April 21, 2009 at 4:30 am
Viewing 15 posts - 39,616 through 39,630 (of 49,571 total)