Viewing 15 posts - 25,171 through 25,185 (of 49,552 total)
SQL 2005 does not have any native backup encryption options. SQL 2008 does (TDE).
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
July 5, 2011 at 10:35 am
SQLkiwi (7/5/2011)
SQLRNNR (7/5/2011)
Could do that - but the networking sometimes is more valuable than attending the courses.To you, or to your employer? 😉
Yes.
The first PASS US Summit I attended my...
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
July 5, 2011 at 10:30 am
Automate what? Your question has no context.
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
July 5, 2011 at 10:27 am
Ok. I'll write it up (carefully). You're warned...
Not really useful information for most people. Internals stuff.
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
July 5, 2011 at 10:24 am
SQLRNNR (7/5/2011)
SQLRNNR (7/5/2011)
Nice question Gail. Can you give us something harder? 😉Can't win them all...
If you want... I have a log internals question that I can submit. The chance...
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
July 5, 2011 at 10:14 am
SQLRNNR (7/5/2011)
Nice question Gail. Can you give us something harder? 😉
I could, but then people would complain.
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
July 5, 2011 at 10:03 am
You can stop a shrink... 😀
Though if this is a once-off after moving tables to different filegroups, it's OK. Just rebuild all your indexes afterwards (and preferably don't shrink the...
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
July 5, 2011 at 9:47 am
Dropping nonclustered indexes I would agree with. There's a point where it is quicker to drop, load and recreate than to load with the indexes.
Dropping foreign key and primary...
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
July 5, 2011 at 9:36 am
Winston Daley-344648 (7/5/2011)
but, every time I see an article about "an introduction to Indexes",
p.s. I hope that's not my 'Introduction to Indexes' article you're talking about... 😉 🙂
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
July 5, 2011 at 8:20 am
Please in future post in the appropriate forum for the version of SQL you are using.
What version (exactly) is the server, what version are the client tools (Help-About)?
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
July 5, 2011 at 8:19 am
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1136467-360-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
July 5, 2011 at 7:37 am
It hasn't returned all the results?
Often SSMS will start displaying results while the query is still running, especially if it's a large resultset.
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
July 5, 2011 at 7:33 am
I'm not one of the editors, but this site publishes what volunteers write and submit. You can request articles (there's a forum specifically for that), but you can't force people...
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
July 5, 2011 at 7:32 am
It's larger. A datetime is 8 bytes, an nvarchar with a date in the most compact form (20110705) takes 18 bytes.
If can't be used with the datetime functions without conversion.
It...
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
July 5, 2011 at 6:52 am
SQL will try to checkpoint all databases before shutdown, but it usually won't have time if windows is shutting down.
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
July 5, 2011 at 5:48 am
Viewing 15 posts - 25,171 through 25,185 (of 49,552 total)