Viewing 15 posts - 46 through 60 (of 259 total)
... And that number will tell you what exactly?
October 9, 2012 at 11:03 am
Reorgs should look something like this:
USE [DatabaseName]
GO
ALTER INDEX [IndexName] ON [dbo].[TableName] REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
Rebuilds would look something like this:
USE [DatabaseName]
GO
ALTER INDEX [IndexName] ON [dbo].[TableName] REBUILD ...
October 9, 2012 at 8:08 am
Make sure your backup is not compressed.
October 9, 2012 at 7:38 am
Don't forget that even in a larger organization or larger team, that jack-of-all-trades mentality is still valuable. Even if you're the master of all things in one particular area...
October 8, 2012 at 2:09 pm
October 8, 2012 at 10:12 am
Thank you for that Randy. It's always good to have the solution for others to find in the future.
October 8, 2012 at 8:14 am
Cliff Jones (10/4/2012)
Revenant (10/4/2012)
anthony.green (10/4/2012)
Daniel Bowlin (10/4/2012)
opc.three (10/3/2012)
DebatableDisputable
dispicable
debatable
Disputable -- Whoa, infinite loop!
Recursion
October 4, 2012 at 9:27 am
Any chance you can share what the attribute was called? As Lowell mentioned he didn't find anything obvious. I did a quick skim through but the list is quite...
October 4, 2012 at 8:01 am
I have to 2nd the sentiments of Ben and the OP. I don't use FB but that may be a nice middle ground. It may not result in more...
October 4, 2012 at 7:56 am
October 3, 2012 at 1:05 pm
You can do this in Management Studio.
- In the Object Explorer, expand Security>Logins.
- Right-click the user/group you want.
- Select "Script login as>Create To>..."
You have several options. You can create...
October 3, 2012 at 1:02 pm
This article may have what you're looking for: http://technet.microsoft.com/en-us/library/dd819505.aspx
September 26, 2012 at 11:51 am
Maybe I'm oversimplifying but your problem may be in this step:
master.dbo.xp_cmdshell 'sqlcmd -Sserver -d database -W -i "C:\SQL\SQLQuery2.sql" -o "C:\SQL\Output\SQLQuery2.sql"'
Your output file is the same name and path as your...
September 24, 2012 at 1:20 pm
a_sql (9/12/2012)
I was asked to peel an Orange at one of my interviews..
This is a necessary skill... if you're applying to work at an Orange Julius[/url]
September 12, 2012 at 12:54 pm
Brandie Tarvin (9/10/2012)
Scott D. Jacobson (9/9/2012)
Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/[/url]The Hacker News comments are interesting as well.
Yeah, the comment that...
September 10, 2012 at 8:59 am
Viewing 15 posts - 46 through 60 (of 259 total)