Viewing 15 posts - 1,936 through 1,950 (of 49,571 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
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...
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 -...
January 6, 2017 at 4:26 am
I'm not sure I understand what results you're trying to get.
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...
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...
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...
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...
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
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,...
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...
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...
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.
January 4, 2017 at 3:01 am
Can you post the table definitions, index definitions and execution plan please?
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.
January 4, 2017 at 2:19 am
Viewing 15 posts - 1,936 through 1,950 (of 49,571 total)