Using query command:
Select @@version
for more info read https://support.microsoft.com/en-us/kb/321185
Sunday, November 1, 2015
Saturday, October 31, 2015
Debugging in Visual Studio
Sometime to debug an web application in Visual Studio, you need to run as Administrator user or for other user.
For more info read: http://stackoverflow.com/questions/1287099/runas-a-different-user-when-debugging-in-visual-studio
For more info read: http://stackoverflow.com/questions/1287099/runas-a-different-user-when-debugging-in-visual-studio
Saturday, September 26, 2015
How many clustered indexes can be in one table?
One clustered indexes per table.
For more info: https://msdn.microsoft.com/en-us/library/ms143432.aspx
Sunday, August 16, 2015
Start SQL Service from Command Line
Sometime open Microsoft SQL Server Studio on local machine, it cannot open the local databases instance, instead of using the GUI, using the command line must more quicker.
net start SQLSERVERAGENT
For more info, see
https://msdn.microsoft.com/en-us/library/hh403394(v=sql.110).aspx#CommandPrompt
net start SQLSERVERAGENT
For more info, see
https://msdn.microsoft.com/en-us/library/hh403394(v=sql.110).aspx#CommandPrompt
Saturday, May 16, 2015
Northwind Sample DB Script is not work on SQL 2014
Comment out the line #24-25 in file "SQL Server 2000 Sample Databases\instnwnd.sql"
sp_dboption removed after SQL 2012
-- exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
=> ALTER DATABASE Northwind SET RECOVERY SIMPLE
-- exec sp_dboption 'Northwind','select into/bulkcopy','true'
=> ALTER DATABASE Northwind SET RECOVERY BULK_LOGGED
Referenece:
Sunday, February 8, 2015
Free Windows 10 Upgrade
As I guessed in my post last year, the next version of Windows is a free upgrade to consumer of Windows 7, 8, and 8.1. I love it.
Labels:
computer,
Microsoft,
operating system,
windows
Subscribe to:
Posts (Atom)