Viewing 15 posts - 31 through 45 (of 212 total)
I want the CHTM format. 😀
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 30, 2014 at 2:34 am
Eirikur Eiriksson (9/30/2014)
Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is {object,column},...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 30, 2014 at 2:24 am
I got it "right" by eliminating 0 and 20, but the answer is incorrect! When I tested the query, I got 5 values in master and I got different numbers...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 30, 2014 at 2:22 am
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Igor Micev (5/21/2014)
Sean Pearce (5/21/2014)
Your...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 23, 2014 at 4:17 am
Nice questions! I got it wrong, but learned a new way of changing the persisted attribute. Dropping and recreating should have worked too, but this is probably easier.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 12, 2014 at 2:25 am
Dave62 (9/8/2014)
SqlMel (9/8/2014)
It does depend.This should be stated in the answer.
No, "it depends" is the default assumption for any SQL Server problem, question, or answer. :w00t:
Enjoy!
It depends is my...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 11, 2014 at 1:46 am
Hugo Kornelis (4/2/2014)
A resultset is being returned...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 2, 2014 at 2:59 pm
+1, but the answers "depends" on Cascades and nullability. This i completely correct (even if I don't like it)
CREATE TABLE dbo.a
(id INT PRIMARY KEY, NAMN VARCHAR(19))
CREATE TABLE dbo.b
(
id INT NULL,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 20, 2014 at 4:37 pm
This question was almost too easy, had to read it 5 times to try to find any pitfalls.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 20, 2014 at 3:49 pm
Easy question, I've been in this situation a couple of times. 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 20, 2014 at 1:55 pm
Wow, interesting question! 😀
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 15, 2014 at 2:36 am
Easy, but important question! Thanks
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 15, 2014 at 2:23 am
Well, it depends:
sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows.
That is,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 14, 2014 at 10:35 am
Paul White (11/3/2013)
The above query does not produce a join. It produces a distinct sort then concatenation of values from one table and the other.
Well it might do,...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 13, 2014 at 9:33 am
Viewing 15 posts - 31 through 45 (of 212 total)