Viewing 15 posts - 6,586 through 6,600 (of 49,571 total)
In SQL Server, you can't take backups at a schema level. Oracle's schemas are closer to SQL Server databases than they are to SQL schemas. If it's a requirement to...
February 10, 2015 at 4:34 am
t.pinder (2/10/2015)
So, we have a DB with 1600+ tables - each with the two boolean fields I mentioned above. Can I change them all to bit? How?
ALTER TABLE ... ALTER...
February 10, 2015 at 2:37 am
Weird.
That's one of the more useless error messages I've seen SQL return too. Nothing more useful in the error log?
February 10, 2015 at 2:13 am
Err, I meant manual backups, as in BACKUP DATABASE ... TO DISK = ....
February 9, 2015 at 9:34 am
below86 (2/6/2015)
February 9, 2015 at 9:27 am
hanialbarni (2/9/2015)
The thing is am 26 I don't want to make any more mistakes in life such as choosing something wrong to study.
So why are you asking us then?...
February 9, 2015 at 9:25 am
nigelevenden (2/9/2015)
And, I would imagine I need to find a trial of an older version of SQL Server rather than buy 2014 Developer Edition.
You imagine wrong 😉
It should be fine...
February 9, 2015 at 9:18 am
subramanyam.mannepalli (2/9/2015)
and if any one please send the resume as sql server developer. to subramanyam......
And why exactly do you want someone's resume? A resume is *your* job and education...
February 9, 2015 at 9:13 am
What do you enjoy?
A certification alone is not going to get you a job, and besides, do you really want a job that you hate?
1 - MCSA - SQL Server...
February 9, 2015 at 8:48 am
Kendra's list doesn't match what I went through either. It's useful, but it shouldn't be used for diagnosis.
February 9, 2015 at 4:20 am
Randomly killing connections is not a solution. At best you're going to have the people simply re-connect and start their queries over, at worst you're going to have reports sent...
February 9, 2015 at 2:26 am
Politely tell the user that the database management is your business and not theirs. Or tell them that their queries are the most expensive and offer to kill them.
Randomly killing...
February 9, 2015 at 1:55 am
Please post the create table statements for each table, some sample data (as insert statements) and your expected results.
February 9, 2015 at 1:49 am
Viewing 15 posts - 6,586 through 6,600 (of 49,571 total)