Viewing 15 posts - 29,836 through 29,850 (of 49,552 total)
Gianluca Sartori (10/20/2010)
If you know how to extract a single query's plan from a procedure plan I'll be glad to post it.
Hmmm... Let me investigate when I get home
Anyway...
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
October 20, 2010 at 5:11 am
paul.knibbs (10/20/2010)
Maybe, but if you've been asked in an interview to do a single restore, I don't see that it's unreasonable to use the GUI to do it.
Absolutely. It's how...
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
October 20, 2010 at 4:56 am
eddywibowo89_new (10/20/2010)
I got the problem in instaling sql server 2005 on my external HDD,
Ok, I'm curious... Why would you install SQL onto an external drive?
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
October 20, 2010 at 4:44 am
IN is for exact matches, not a between or range search.
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
October 20, 2010 at 4:28 am
Henrico Bekker (10/20/2010)
Typing "Sel" or "Ins" etc...and pressing Tab, waiting for auto complete...like cmd.....:pinch:
Get SQLPrompt
Type 'SE' *Ctrl-Space* *Enter* -> Select
Or type 'ssf' *Tab* -> SELECT * FROM
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
October 20, 2010 at 4:23 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1007555-391-1.aspx
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
October 20, 2010 at 4:12 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1007555-391-1.aspx
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
October 20, 2010 at 4:11 am
Sure it's possible. Links (I assume you're referring to foreign keys) are not required in order to join tables in a query.
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
October 20, 2010 at 4:03 am
SQL* (10/20/2010)
how impersonation can be used?if i have created a user(imporuser) with out login,
then how that user can be used?
Look up EXECUTE AS in SQL Books Online (hint, there...
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
October 20, 2010 at 4:00 am
SEELCT * FORM ....
CRATE TABEL ....
CRATE IDNEX ...
I love SQLPrompt.
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
October 20, 2010 at 3:36 am
As I said
GilaMonster (10/20/2010)
Since it has no login, it can only be used for impersonation
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
October 20, 2010 at 3:34 am
Query sys.dm_db_index_physical_stats.
The column avg_fragmentation_in_percent is logical fragmentation if the row in question is for a clustered or nonclustered index, or extent fragmentation if the object in question is a heap.
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
October 20, 2010 at 2:47 am
Gianluca Sartori (10/20/2010)
Are you sure that that much time is being spent doing lookups?
This is what I see from the exec plans on the heaviest and most executed queries on...
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
October 20, 2010 at 2:21 am
No, typically not.
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
October 20, 2010 at 2:18 am
A cluster uses shared disks. There's only one copy of the database files on the shared storage and only one active instance of SQL (unless we're talking about multi-instance clusters)
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
October 20, 2010 at 2:17 am
Viewing 15 posts - 29,836 through 29,850 (of 49,552 total)