Viewing 15 posts - 6,406 through 6,420 (of 49,552 total)
Google: "Gaps and Islands Itzik Ben-gan"
That should get you started.
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
March 18, 2015 at 4:18 am
Index definitions (CREATE INDEX) and table definition please. I think I know what's going on, but need confirmation.
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
March 18, 2015 at 3:16 am
What's the definition of the table and index (CREATE statements 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
March 18, 2015 at 3:03 am
Firstly why are you regularly shrinking your database?
AFAIK the error's from the log's trying to auto-grow while you have a shrink running. Solution: stop shrinking the log, if it's reaching...
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
March 18, 2015 at 2:59 am
Luis Cazares (3/17/2015)
Can someone help with a crystal ball or interrogation system for this thread?http://www.sqlservercentral.com/Forums/Topic1668185-391-1.aspx
Sorry, mine's broken, it's only showing clouds.
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
March 18, 2015 at 2:54 am
There is some external application running on the local server connecting to SQL as sa.
It is not an internal SQL background process, they do not need to log in and...
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
March 18, 2015 at 2:53 am
Books Online (the SQL help file) 🙂
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
March 17, 2015 at 9:10 am
John suggested what you should do.
John Mitchell-245523 (3/17/2015)
If you want to rely on index usage stats, I would recommend that you collect and store them regularly, perhaps every 30 minutes.
Set...
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
March 17, 2015 at 8:45 am
No, SQL doesn't track object change history.
You can look at sys.objects in each database and look at the create_date and modify_date, but I think there are things you can do...
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
March 17, 2015 at 8:41 am
No, that's something external trying to connect. The system tasks don't need to log in. They're internal.
I prefer disable, as I've seen a case before where a service pack installation...
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
March 17, 2015 at 7:27 am
gopisrinivas.t (3/17/2015)
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
March 17, 2015 at 5:53 am
kangarolf (3/17/2015)
The alternative is to normalise and go with relationship tables.
Yup.
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
March 17, 2015 at 5:50 am
You shouldn't be touching the minimum memory for query without a really, really good reason. The max server memory however should almost always be changed from the default, as few...
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
March 17, 2015 at 5:48 am
jshahan (3/16/2015)
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
March 17, 2015 at 2:56 am
Randy Doub (3/16/2015)
Is there ANY way I can get a "backup" of the Standby/Read-Only database that can be put in place as a Standby/Read-Only and used?
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
March 17, 2015 at 2:49 am
Viewing 15 posts - 6,406 through 6,420 (of 49,552 total)