Viewing 15 posts - 31 through 45 (of 54 total)
MSSQL_NOOB (3/28/2013)
I set DB to Full Recovery Model. I have a DB backup once a day and log backups every 30 minutes or so using the...
March 28, 2013 at 9:39 am
Sunny03 (3/28/2013)
One of the user come up with Timeout expired issue for one of the instance....
March 28, 2013 at 9:25 am
As a second thought, Use BCP (Bulk Copy Program)
March 28, 2013 at 6:07 am
If it is one off then you can use Sql Studio to export the results to a file.
Menu->Query->ResultTo->File.
March 28, 2013 at 6:06 am
charipg (3/28/2013)
not able to connect after changing the port number.
What with?
Where from?
What did you change from what to what?
If you can try running this code on the SQL server that...
March 28, 2013 at 6:01 am
I think this is what you want:
;
with CTE as (
SELECT 'International' Campus,28 'Weeks-2013',0 'Weeks-2012',2 'Student-2013',0 'Student-2012',0 StudentPrevYrTotal
UNION
SELECT 'International' Campus,32 'Weeks-2013',0 'Weeks-2012',1 'Student-2013',0 'Student-2012',0 StudentPrevYrTotal
UNION
SELECT 'International' Campus,0...
March 28, 2013 at 3:43 am
Make certain that you have completely flooded out the SAN cache which can be 10GBs in size.
A very simple way is to create a database with 100GB log. It needs...
March 28, 2013 at 3:24 am
Chris,
Often the style gets ignored or overridden by the character string being in a different state. It also keeps the time element which seems to me slighty at odds compared...
March 27, 2013 at 10:47 am
Tis why I avoid passing comment straight away 🙂
March 27, 2013 at 10:32 am
Steve JP (3/26/2013)
....
The issue with the convert is that the 3rd arguement is the style and is used to set the style when you convert from a datetime to a...
March 27, 2013 at 6:30 am
SELECT DateAsCharacter = CONVERT(VARCHAR(25),GETDATE(),100)-- 'Mar 26 2013 12:49PM'
SELECT DateAsDate = CONVERT(DATETIME,'Mar 26 2013 12:49PM',100)
-- 2013-03-26 12:49:00.000
Dont totally agree with this as the following will error which is as I expect...
March 27, 2013 at 4:43 am
denis.gendera (3/20/2013)
I'm having strange issue trying to do the following which I thought was just going to be straight forward
select top 5 machine.name, machine.model, machine.scantime
'INSERT INTO [SMS_000].[dbo].[BMCMachines] ([ComputerName],[MachineModel],[stime])...
March 26, 2013 at 4:05 am
I'm aware that this might not be answering your question but you can still insert rows into the table which has an incremental column:
drop table [Test auto inc]
create table [Test...
March 26, 2013 at 3:55 am
To my knowledge the binnaries are always installed on C: All the databases can be installed/moved to different locations. But why do you want them somewhere else?
March 26, 2013 at 2:53 am
Viewing 15 posts - 31 through 45 (of 54 total)