Viewing 15 posts - 5,731 through 5,745 (of 49,552 total)
Books Online works, otherwise use the books/training resources for the exams which it replaces. Upgrade exams don't tend to get books.
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
June 1, 2015 at 9:03 am
Sure, toss them my way
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
June 1, 2015 at 8:17 am
You'll need to query every single table and search on every single column.
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
June 1, 2015 at 3:16 am
The clustered index is the table, so deleting it won't help you.
If the data isn't important, how about archiving or deleting old data?
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
June 1, 2015 at 2:23 am
Eirikur Eiriksson (5/31/2015)
Quick suggestion, log on to the server and run SSMS as Administrator, should be able to connect from there.
Won't help, Administrator is not a default SQL login, not...
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
May 31, 2015 at 4:14 pm
It's not, unless when you set the replication up, you configured it to use the sa account (which is not default iirc)
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
May 31, 2015 at 4:10 pm
Jeff Moden (5/30/2015)
2. In the case of things like "hicks2001" "conference:06", what do you want...
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
May 31, 2015 at 12:32 pm
That's not going to work at all.
declare @moneyid int
select @moneyid = moneyid from inserted
You're assuming there's only ever one row updated at a time. When more than one row is...
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
May 31, 2015 at 6:28 am
With the trigger code there, that's not possible. That trigger will write into the audit table the rows which were affected by the delete with the host name and user...
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
May 31, 2015 at 3:16 am
Unless you had some monitoring in place at the time of those events, you probably can't figure out the cause.
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
May 31, 2015 at 3:13 am
Probably not, the error log would be a far more likely place to have that info.
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
May 31, 2015 at 3:12 am
Steve Jones - SSC Editor (5/29/2015)
You'd think it was still winter.
But it is.
Warm winter at the moment, but it's definitely winter (dry as anything)
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
May 31, 2015 at 3:10 am
Lynn Pettis (5/29/2015)
Eirikur Eiriksson (5/29/2015)
Sometimes I do wonder where things went wrong with MS and...
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
May 31, 2015 at 3:08 am
Steven W (5/29/2015)
I don't use any clustered indexes actually... all of mine are non-clustered...
Errr.. wha?
That's a really odd decision seeing as the SQL storage engine is designed with the idea...
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
May 31, 2015 at 3:07 am
No feature, just a rather large pile of manual work.
You'll need to take the table create statements and change the data types to match Oracle, you'll need to check every...
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
May 29, 2015 at 9:56 am
Viewing 15 posts - 5,731 through 5,745 (of 49,552 total)