Viewing 15 posts - 31,831 through 31,845 (of 49,552 total)
hxkresl (7/14/2010)
a product catalog would surely require FILESTREAM.
Why do you say that?
Is it not possible to have a product catalog without filestream?
Don't make assumptions in an exam. If...
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
July 14, 2010 at 4:13 pm
Please post your question in a new thread. Thank you.
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
July 14, 2010 at 3:21 pm
Script Table As -> ALTER To - grayed out??? Why?
Probably because the only portion that could be sensibly scripted out without further knowing what you're doing would be
ALTER TABLE <Table...
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
July 14, 2010 at 3:02 pm
paul.wetzel (7/14/2010)
If you use the .Net SQLParamater, it will not allow that value
Why not?
Just parameterising the call to the proc is not sufficient to protect against injection if there's dynamic...
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
July 14, 2010 at 12:03 pm
Parameter sniffing?
Looks like the app is a stored proc call (or parameterised SQL) and the management studio is ad-hoc SQL. The row count estimates are quite wrong on the one...
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
July 14, 2010 at 11:28 am
They're tables related to the allocation structures of tables and indexes. Got a lot of tables?
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
July 14, 2010 at 11:26 am
Counts me out then. Maybe Kevin (TheSQLGuru) is interested.
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
July 14, 2010 at 9:46 am
Might be useful to state whereabouts you are, seeing as you're asking possibly for a consultant.
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
July 14, 2010 at 9:32 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
July 14, 2010 at 9:32 am
DaniSQL (7/14/2010)
The switch to Simple recovery model takes effect only after you take a full backup.
A switch to Simple takes effect immediately. It's a switch from simple to either...
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
July 14, 2010 at 9:31 am
Ashwani Malik (7/14/2010)
Here is another way to rebuild the log file if you do not have oneCREATE DATABASE Sql_database2
ON
(FILENAME = 'F:\MSSQL\\data\Sql_database2_data.mdf')
for ATTACH_REBUILD_LOG
GO
That will only work if the database was...
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
July 14, 2010 at 9:27 am
Please note: two year old thread.
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
July 14, 2010 at 9:05 am
Follow the steps here:
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
July 14, 2010 at 7:47 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
July 14, 2010 at 7:47 am
Yes. The Reorganise operation is always online, there's no specific option that you need to specify.
It's not as good as rebuilding the index, especially with high fragmentation, but better than...
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
July 14, 2010 at 7:43 am
Viewing 15 posts - 31,831 through 31,845 (of 49,552 total)