Viewing 15 posts - 34,261 through 34,275 (of 49,552 total)
I mean non-SQL based encryption.
If the encryption is done in the database (certificate/key), then anyone with sysadmin rights has permission to open the key and decrypt the data. 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
February 3, 2010 at 5:13 am
Bhuvnesh (2/3/2010)
Does it mean that if space available and for temporary storing purpose, we can store milions of record in table variable? (this is just hypothentical scenario )
There is no...
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
February 3, 2010 at 12:09 am
Because the join isn't necessary. All you're trying to do is find rows that exist in the other table. So why not use EXISTS?
One of these may have been the...
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
February 3, 2010 at 12:05 am
What indexes exist on the table dms_topic_entry? If this is a key-lookup deadlock (as I suspect) then simply widening the index to be covering will fix this completely.
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
February 3, 2010 at 12:02 am
I don't think those are statistics. From the naming, they're DTA-created indexes, either real or hypothetical. Try DROP INDEX.
btw, I don't think that the "enforced dependencies" refers to indexes. Check...
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
February 2, 2010 at 11:57 pm
So am I correct in saying that you have no primary key and no clustered index on this 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
February 2, 2010 at 11:45 pm
Bhuvnesh (2/2/2010)
So is this only reason we should avoid table variable for heavy count of records. ?
That and its limited indexing capabilities
or it also has small capacity to hold...
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
February 2, 2010 at 11:39 pm
Wait.
It has to finish rolling back. There is no way to stop a rollback, what was done before you cancelled the query has to be undone.
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
February 2, 2010 at 12:02 pm
Gianluca Sartori (2/2/2010)
On the last one you almost corrected Jeff on the LDFs thing, so I think you have the answer.:-D
I realised what he meant. Just the way it 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
February 2, 2010 at 11:36 am
Digs (2/1/2010)
A sort order for an Index..Is that wise ???
Indexes are always sorted. By default ASC if no option is specified.
For example I have one column filled with BIT or...
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
February 2, 2010 at 10:44 am
I'm fast losing both patience and hope. The last month, it feels like I've been correcting almost as many replies as I have been answering questions
http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286
http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344
http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992
Am I getting too picky?
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
February 2, 2010 at 10:34 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
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
February 2, 2010 at 10:26 am
You can do that, but IF is control flow and not part of a SQL statement, hence you must put complete insert statements within the IF blocks
IF @PeriodType = 'Monthly'
BEGIN
...
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
February 2, 2010 at 9:47 am
What are you trying to do? What are you trying to achieve?
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
February 2, 2010 at 9:10 am
See the article I posted earlier for the exec plan
For IO stats
SET STATISTICS IO ON
then run the 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
February 2, 2010 at 8:32 am
Viewing 15 posts - 34,261 through 34,275 (of 49,552 total)