Viewing 15 posts - 9,901 through 9,915 (of 49,571 total)
Views don't have timeouts.
Timeout is an application setting. It's the application deciding it's waited too long for SQL Server to respond and the application then sends a request to...
February 25, 2014 at 6:52 am
quackhandle1975 (2/25/2014)
February 25, 2014 at 6:37 am
What recovery model is the database in?
Where are all the other log restores? You need to restore all the log backups in sequence from the time of the full backup...
February 25, 2014 at 5:01 am
pdanes (2/25/2014)
So if the query gives me what I need, I should ignore whatever the design view says?
Better yet, avoid design view entirely.
I'm kind of leery about ignoring warning messages...
February 25, 2014 at 1:42 am
The design view is a piece of crap that barely works and only supports a subset of the T-SQL language.
February 25, 2014 at 1:22 am
Right, since it's case sensitive, any user data types (and that includes sysname) have to exactly match in case what they're specified in sys.types. Database names have to exactly match...
February 24, 2014 at 7:36 am
Appears this question has been reposted elsewhere. Further replies to the following thread please http://www.sqlservercentral.com/Forums/Topic1544461-391-1.aspx
February 24, 2014 at 7:29 am
stormsentinelcammy (2/24/2014)
GilaMonster (2/24/2014)
Tune the query, tune the indexes. Without more information that's about all that can be said.
Also, if you have an inline table switch to a temp table so...
February 24, 2014 at 7:26 am
Table variable. Insert into the table variable during the transaction. Table variables aren't affected by explicit rollbacks, after the rollback you can then insert the data into a permanent table.
February 24, 2014 at 7:26 am
michael.higgins (2/24/2014)
GilaMonster (2/24/2014)
michael.higgins (2/24/2014)
Here is me assuming it's 2008 :blush: What is it they say about assuming !
Yeah, I mean it's the SQL Server 2008 forum, surely it must be...
February 24, 2014 at 7:15 am
michael.higgins (2/24/2014)
Here is me assuming it's 2008 :blush: What is it they say about assuming !
Yeah, I mean it's the SQL Server 2008 forum, surely it must be SQL Server...
February 24, 2014 at 7:13 am
GilaMonster (2/24/2014)
I asked on your other thread but got no answer, is your instance case-sensitive?What's the exact version of SQL Server that you're working with?
i.e. version, service pack, edition, etc...
February 24, 2014 at 7:12 am
Viewing 15 posts - 9,901 through 9,915 (of 49,571 total)