Viewing 15 posts - 7,486 through 7,500 (of 49,552 total)
Because GO separates code into batches and SQL parses and executes batches separately.
A batch is a set of commands sent to a server. Hence, if you run this:
CREATE PROCEDURE...
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
October 16, 2014 at 2:25 pm
You can get the same message with a differential. I've seen it before when a full was made one way (native backup) and the diff was run with something else...
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
October 16, 2014 at 2:19 pm
Developer edition is the equivalent of Enterprise edition in terms of features, but it is licensed for non-production usage only. You may not use it for production systems at all.
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
October 16, 2014 at 12:24 pm
Look at the red underline in the very first line of the script that you posted. It's pointing to exactly what the problem is.
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
October 16, 2014 at 7:20 am
Look at the very first red underline in that screen shot (on the very first line), that's your problem.
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
October 16, 2014 at 7:00 am
Is the instance running with any trace flags enabled? Are row or page locks disabled on the index?
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
October 16, 2014 at 6:59 am
Yup, and it's about the only practical way of doing this.
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
October 16, 2014 at 6:58 am
.
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
October 16, 2014 at 6:58 am
Define a parameter, or pass a parameter? Since you do both in your first post, I don't understand why you're asking.
Quote from your very first post (parameter definition in bold).
CREATE...
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
October 16, 2014 at 6:49 am
Elliswhite (10/16/2014)
Execute GetBooksbyBorrowerID
Where's the parameter?
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
October 16, 2014 at 6:35 am
Sure.
http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7279
I got to inequalities around half way through.
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
October 16, 2014 at 4:59 am
Kummu (10/16/2014)
I read somewhere that, when we change the recovery model of a database from FULL to SIMPLE or SIMPLE to FULL to BULK. All previous backups become invalid.
Nope, 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
October 16, 2014 at 3:54 am
dwilander (10/15/2014)
I think the 64 bit version can hold an 8GB database, otherwise 4GB (am I right folks?).
10GB for SQL 2008 R2 and later. 64bit vs 32 bit...
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
October 16, 2014 at 2:39 am
Ok, so to confirm:
You need to be able to add views and tables to the reporting database
You don't need to change existing tables (tables from the primary)
You don't need 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
October 16, 2014 at 2:33 am
TheSQLGuru (10/15/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
October 15, 2014 at 11:57 am
Viewing 15 posts - 7,486 through 7,500 (of 49,552 total)