Viewing 15 posts - 136 through 150 (of 1,179 total)
SQLRNNR (6/4/2014)
EZ PZ lemon SQEEZEE
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 11:57 pm
what is .mpmp format?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 5:48 am
It would be advisable to create the code and than execute it so that you can have more control. If you directly performing chang in your code it happens in...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 4:12 am
If you feel that Transaction log is filling quickly and would like to find out the issue...
1. You can start SQL Server trace for the specific database to find...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 4:05 am
By executing following command:
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdb1', SIZE = 5120000KB, FILEGROWTH = 1024000KB, FILENAME = '<path>\tempdb1.ndf' )
GO
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 1:16 am
Yes, you can add secondary file(.ndf) to tempdb.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 1:00 am
Easy one, thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 4, 2014 at 12:52 am
robertjtjones (6/3/2014)
Cheers Andy - had to start off with all of them and eliminate one by one this time 🙂
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 3, 2014 at 3:04 am
You can have trusted domain. If not possible you can BCP/SSIS to CSV file, transfer file to destination location and do BCP/SSIS in.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2014 at 4:57 am
Execute following command to find the status:
select name, page_verify_option_desc from sys.databases
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2014 at 4:52 am
There is nothing to do with database restore and Tempdb growth. Tempdb is used for the different purpose; check BOL.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 2, 2014 at 4:45 am
Thank you, Steve. Easy One.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 1, 2014 at 11:32 pm
Good One!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 30, 2014 at 1:43 am
How about creating VIEW? will it work?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 27, 2014 at 3:50 am
Refer following link for the query:
http://stackoverflow.com/questions/20085249/import-excel-spreadsheet-data-to-an-existing-sql-table
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 27, 2014 at 2:52 am
Viewing 15 posts - 136 through 150 (of 1,179 total)