Viewing 15 posts - 181 through 195 (of 212 total)
You will find it the cause of this if you look at the Execution plan. The SQL optimizer uses a table scan to get "ch" from the first row since...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 23, 2009 at 1:05 am
MarkusB (4/16/2009)
I had a couple of times that a report gave an error the first time I used...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 16, 2009 at 2:41 am
Have you tried it your self?
I installed it in my development environment and as i can see there are some defects in the setup script that creates the functions used...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 16, 2009 at 2:33 am
It is not a bug, its a conversion error, due to the fact that the number 11 is an int and SQL tries to convert the result to the nearest...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 9, 2009 at 12:24 am
Thank you for pointing out this bug in SQL server, i was pretty sure that answer no 1 would be the correct one, but i was wrong. It surely is...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
April 9, 2009 at 12:11 am
I think this is an Incorrect question! How do you update the FILESTREAM column without updating the row?
Håkan Winther
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 25, 2009 at 2:05 am
For your information, the NWlink protocol is not supported any more according to books online
Microsoft SQL Server does not support the Banyan VINES Sequenced Packet Protocol (SPP), Multiprotocol, AppleTalk, or...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 21, 2009 at 5:59 pm
Someone may think this is a feature, but i think it is sad that SQL doesnt handle this as an error due to the fact that it is to easy...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 17, 2009 at 3:13 am
Simon Facer (3/12/2007)
ALTER INDEX with REORGANIZE is a better option, but INDEXDEFRAG is still available ( ). Bad question!!!
The question is correct as far as i am concerned, because DBCC...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 11, 2009 at 2:44 am
Bert Carles (10/2/2006)
Technically, NONE of the provided answers are correct. I thought we'd gotten beyond these bogus questions
I totally agree, it is frustrating that there is no correct answer.
/Håkan...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 10, 2009 at 3:35 am
GilaMonster (3/5/2009)
Search google. You should find some links to products that do that (I don't think any are free)
Thanks for your tip! 🙂
I found a lot of samples by...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 5, 2009 at 2:44 am
This is what SQL Server books online say about encryption:
ENCRYPTION
Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 5, 2009 at 2:10 am
ansar.vma (3/5/2009)
I have just installed SQl Server 2008 in my machine. The problem i am not able to find the Acitivty monitor (in SQL Server 2005 which was show...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 5, 2009 at 12:55 am
I am sorry, to use the link you need to have books online for SQL Server 2008.
Use this link:
http://msdn.microsoft.com/en-us/library/ms189852.aspx
or
http://msdn.microsoft.com/en-us/library/bb895393.aspx
or
http://msdn.microsoft.com/en-us/library/ms190202(SQL.90).aspx
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 24, 2009 at 2:43 am
You have to open books online for SQL server an paste the link in the address bar.
/Håkan
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
February 24, 2009 at 2:40 am
Viewing 15 posts - 181 through 195 (of 212 total)