Viewing 15 posts - 1,936 through 1,950 (of 49,552 total)
Please don't post multiple threads for the same question.
No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1848217-3739-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
January 6, 2017 at 4:30 am
Restore or attach the database you downloaded to your local instance (restore if you downloaded a backup, attach if you downloaded database files)
To connect to your local instance, just enter...
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
January 6, 2017 at 4:29 am
daniel.sousa (1/6/2017)
2017/1/06 - 00:00 -> 2017/1/06 - 01:00
2017/1/06 - 01:00 -> 2017/1/06 - 02:00
2017/1/06 - 02:00 -> 2017/1/06 - 03:00
2017/1/06 -...
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
January 6, 2017 at 4:26 am
I'm not sure I understand what results you're trying to get.
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
January 6, 2017 at 4:03 am
With just that information, no.
Can you give us more detail on the query, its execution plan at the very least?
Keep in mind that when a query parallels, one thread WILL...
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
January 6, 2017 at 3:58 am
JasonClark (1/4/2017)
Yes, you are correct.You may also try this to check the version and edition of SQL Server installed on your machine:
<Snip long and involved method>
Or, just run SELECT @@VERSION.
Neither's...
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
January 5, 2017 at 2:22 am
Hugo Kornelis (1/4/2017)
GilaMonster (1/4/2017)
Hugo Kornelis (1/4/2017)
Note that both for the versions in your post as well as for the versions given by Eirikur, only some work correctly for nullable columns.
I...
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
January 4, 2017 at 9:00 am
Hugo Kornelis (1/4/2017)
Note that both for the versions in your post as well as for the versions given by Eirikur, only some work correctly for nullable columns.
I don't think any...
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
January 4, 2017 at 8:51 am
Why not use the DMVs?
SELECT t.name AS TableName, referencing_schema_name AS ReferencingSchema, referencing_entity_name AS ReferencingObject
FROM sys.tables t
CROSS APPLY sys.dm_sql_referencing_entities(SCHEMA_NAME(t.schema_id) + '.' + t.name, 'object')
ORDER BY TableName
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
January 4, 2017 at 7:43 am
Repost from Twitter:
Research for a blog post: What are the common forms of 'catch-all' / 'multi-parameter query' you've seen?
I've seen:
(Col = @C1 or @C1 is NULL)
Col = COALESCE(@C1,...
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
January 4, 2017 at 6:55 am
The definitions of EventStatusInsTrg and copytoarchive please?
Also consider seeing whether management would be willing to get a consultant in to help you out (several of the regulars here...
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
January 4, 2017 at 6:48 am
ichervin (12/27/2016)
How to recover a database if an encryption key is lost?
UR;LT
Seriously, what is your exact situation?
TDE database with no certificate backup, but database still open and usable?
TDE backup, 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
January 4, 2017 at 6:46 am
Web services are usually written in C# or similar languages.
The native web services feature mentioned above was deprecated in SQL 2008 R2 and removed entirely in SQL 2012.
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
January 4, 2017 at 3:01 am
Can you post the table definitions, index definitions and execution plan please?
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
January 4, 2017 at 2:46 am
JasonClark (1/3/2017)
There are many symptoms which points in the direction of the error 5171.
However in this case it's because he tried to attach a backup instead of restoring it.
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
January 4, 2017 at 2:19 am
Viewing 15 posts - 1,936 through 1,950 (of 49,552 total)