Viewing 15 posts - 6,586 through 6,600 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2015 at 2:13 am
Err, I meant manual backups, as in BACKUP DATABASE ... TO DISK = ....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 9:34 am
What does a manual backup fail with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 9:29 am
below86 (2/6/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 8:48 am
https://www.microsoft.com/learning/en-us/sql-certification.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 4:54 am
Kendra's list doesn't match what I went through either. It's useful, but it shouldn't be used for diagnosis.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2015 at 1:49 am
Viewing 15 posts - 6,586 through 6,600 (of 49,552 total)