Viewing 15 posts - 10,981 through 10,995 (of 22,214 total)
Retire? What's that word mean?
I'll be a geek til the day I die. If I'm lucky, I'll get paid for it most of the way.
April 27, 2012 at 4:47 am
danaanderson (4/26/2012)
April 27, 2012 at 4:38 am
20,000 rows is not that much. Even tripling it to 60,000 rows is still not much. Returning four columns doesn't mean much because I don't know the data types of...
April 26, 2012 at 1:21 pm
If FK3 is used in queries where the other two columns are not referenced in either JOIN criteria or WHERE clauses, then yeah, it might benefit from a nonclustered index....
April 26, 2012 at 1:17 pm
Larry Page(Ehsan.Akbar) (4/26/2012)
Mark Fitzgerald-331224 (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
April 26, 2012 at 10:53 am
There are a bunch of ways ot tell what version of SQL Server you have. Microsoft has them documented here. The best is to query directly:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY...
April 26, 2012 at 10:22 am
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
April 26, 2012 at 7:45 am
Thomas Stringer (4/26/2012)
Great information and summary, Grant.
Thanks. I've had a little practice laying out that information though, so it's not that big an accomplishment.
April 26, 2012 at 7:44 am
I found a bug in AlwaysOn. Anyone want to vote on it?
April 26, 2012 at 7:43 am
Looks like it's a bug. I just submitted this on Connect if you want to go vote for it.
April 26, 2012 at 7:39 am
Larry Page(Ehsan.Akbar) (4/26/2012)
Grant Fritchey (4/26/2012)
April 26, 2012 at 6:59 am
Looks like everything is retyped for us to hide things, but based on what's typed, it's saying the VALUE is the problem, not the column name.
April 26, 2012 at 6:58 am
I just did a series of tests with my AlwaysOn test environment. I failed over multiple times on an existing database, AdventureWorks2008R2. I didn't see the reseed occur. I tried...
April 26, 2012 at 6:52 am
I was going to say the same thing. Check the data on the other server. That must be where the duplicate is.
April 26, 2012 at 5:32 am
Usually that would be an indication of a full drive. There must be an error or a message or something.
April 26, 2012 at 5:29 am
Viewing 15 posts - 10,981 through 10,995 (of 22,214 total)