Viewing 15 posts - 1 through 15 (of 135 total)
thanks to all and TheSQLGuru
Ali
MCTS SQL Server2k8
September 18, 2014 at 3:27 am
GilaMonster (8/8/2014)
SQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't,...
Ali
MCTS SQL Server2k8
September 18, 2014 at 3:26 am
Try this for SQl Sever 2008 R2 Enterprise
exec xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup\Client_Components_Full','ProductCode'
Ali
MCTS SQL Server2k8
May 29, 2014 at 11:18 pm
Jacob Wilkins (8/7/2013)
From http://msdn.microsoft.com/en-us/library/bb500469(v=sql.120).aspx"SQL Server 2014 is available in 32-bit and 64-bit edition."
Seems clear 🙂
Cheers!
From where to Download 32 bit SQL Server 2014, On MS site its showing only for...
Ali
MCTS SQL Server2k8
August 27, 2013 at 2:54 am
M
Lowell (9/6/2012)
Ali Tailor (9/6/2012)
HiI am wondering for; Will SQL Profiler will capture trace for the hard coded
query in application.
Answers will be thankfull.
a profiler session or a server side trace can...
Ali
MCTS SQL Server2k8
September 6, 2012 at 7:12 am
Hi
I think no need to restart server,restaring sql service
may solve the problem.
Ali
MCTS SQL Server2k8
June 19, 2012 at 12:57 am
SKYBVI (12/21/2010)
Does education (bachelor's or master's) also influence the pay in case of SQL server DBA ??Regards,
Sushant
Sushant answer is Yes. My condidature was canceled by Clover infotech mumbai in April...
Ali
MCTS SQL Server2k8
June 14, 2012 at 8:52 am
I am having 4yr as Application support exc. and 1 yr as Jr. Dba and in Dec 11. I got new job with a 40% hike with no night shift....
Ali
MCTS SQL Server2k8
June 14, 2012 at 8:20 am
SQLDBA ARJUN (4/17/2012)
Folks,Can we increase the query Execution Time and what is the execution time of query.by default it is 30 secsl.
Hi
Arjun are you sure about increasing query exic...
Ali
MCTS SQL Server2k8
April 17, 2012 at 11:41 pm
Hi
Is your function running same log in and Or have permission on object.
Ali
MCTS SQL Server2k8
November 23, 2011 at 11:42 pm
You are right, And also you will asked for selection of instance if there more than one,
Ali
MCTS SQL Server2k8
November 14, 2011 at 1:37 am
Hi
Download MAP trainning Kit from:
http://technet.microsoft.com/en-us/solutionaccelerators/dd537566.aspx
:-)It may help you.
Ali
MCTS SQL Server2k8
November 11, 2011 at 12:12 am
SQLRNNR (11/8/2011)
Denali has been renamed to SQL 2012
Means Microsoft Not releasing SQL server 2011, They are releasing Denali as SQl server2012?
THanks
Ali
MCTS SQL Server2k8
November 9, 2011 at 10:38 pm
Hi,
SQL server Denali is 2011 or 2012.
Plaease cleare me. Thanks.:cool:
Ali
MCTS SQL Server2k8
November 8, 2011 at 11:35 pm
You can find same thing in one line, by using only
select @@version
Ali
MCTS SQL Server2k8
November 8, 2011 at 10:57 pm
Viewing 15 posts - 1 through 15 (of 135 total)