Viewing 15 posts - 766 through 780 (of 1,179 total)
Batch file is nothing but simply a Text file which contain bunch of data/records/commands. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2010 at 4:06 am
As far as I know price is same for 32 bit and 64 bit but better check with the vendor.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 4, 2010 at 3:59 am
just try with b.id = a.id
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2010 at 4:43 am
Author could have eliminate the answer option "Error Message" from Question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2010 at 3:17 am
Question asked do not mention anything about table tblUsers
When executed the query ;
WITH Users(UserID, UserName) AS
(
SELECT TOP 1 intUserID, strUserName FROM tblUsers
)
SELECT TOP 2 tblUsers.*, Users.* FROM tblUsers, Users
Reults...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 3, 2010 at 3:14 am
As suggested by Gila it would be gerat if you can shar the performance data.
However SQL Server is running TB of data and billions of rows in a table without...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 6:21 am
SQL will run smoothly for 250 GB of data on 8 GB RAM depending your application and load.
First of all let me tell you that it's not always correct that...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 5:44 am
I am not sure what you actually looking for?
following will give you the details of the created partition fucntions.
SELECT * FROM sys.partition_functions
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 5:34 am
Hello EdVassie,
Thanks for sharing this in detail 🙂
I was not sure about the master and done the location change for all systemdatabase. I was fortunate that nothing happen and everything...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 4:17 am
SQL Server 2005 Standard & Enterprise Edition supports Operating system Maximum RAM.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 3:33 am
Except occupying a little disk space; which won't bother you 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 3:26 am
Provide more and specific detail like What OS version and edition you will be using and what SQL Server edition you are considering?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 3:21 am
role SQLAgentUserRole will able to perform this considering he owns the job. Refer the following link for further detail.
http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 2, 2010 at 3:14 am
For production environment it's not advisable to put change recovery model from Full to Simple to shrinkfile. If you do so you need to take Full backup ASAP.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 25, 2010 at 6:28 am
I do not think for DB which is in Simple recoevery will help.
But you can do the same for Full recovery DB if you wish but make sure you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 25, 2010 at 6:25 am
Viewing 15 posts - 766 through 780 (of 1,179 total)