Viewing 15 posts - 9,901 through 9,915 (of 49,552 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...
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 25, 2014 at 6:52 am
quackhandle1975 (2/25/2014)
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 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...
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 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...
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 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.
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 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...
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 24, 2014 at 7:36 am
4th time... Is your server case-sensitive?
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 24, 2014 at 7:33 am
Appears this question has been reposted elsewhere. Further replies to the following thread please http://www.sqlservercentral.com/Forums/Topic1544461-391-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
February 24, 2014 at 7:29 am
nm
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 24, 2014 at 7:28 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...
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 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.
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 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...
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 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...
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 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...
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 24, 2014 at 7:12 am
Local machine and server on the same domain?
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 24, 2014 at 7:11 am
Viewing 15 posts - 9,901 through 9,915 (of 49,552 total)