Viewing 15 posts - 11,866 through 11,880 (of 49,552 total)
LiveSqlHelp (8/31/2013)
I would avoid the loop, create a temp table named #temp and insert the values of the Years from 2000 to 2010.
And you would do that without a loop...
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
August 31, 2013 at 10:35 am
You've got IO subsystem problems on ServerA. Do some diagnostics, check storage logs and consider moving the DB to alternate storage.
Corruption can't be replicated (or mirrored), so bad pages...
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
August 31, 2013 at 10:31 am
Google: tally table (or dates table maybe)
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
August 31, 2013 at 5:28 am
SQLAli (8/31/2013)
Yes, we can rename the instance by using the below commands. I have also involved once in this activity.sp_dropserver 'old servername'
go
sp_addserver 'new servername'
go
That does not rename a named instance....
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
August 31, 2013 at 5:27 am
Partitioning is not simple and it's not primarily for performance.
Filtered indexes are nice, but they're not simple either and there are lots of scenarios where they can't be used by...
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
August 31, 2013 at 3:57 am
Snigdha Vartak (8/30/2013)
Certification will definitely get you more money
Not necessarily.
As of last night, there are now 0 certifications that one can take that I will immediately respect. MCITP/MCTS/MCSA/MCSE tell me...
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
August 31, 2013 at 3:45 am
Just ....
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday...
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
August 31, 2013 at 3:43 am
Jay Purvis (8/30/2013)
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
August 30, 2013 at 1:31 pm
You could, but why would you want to? Restoring a backup's going to be faster and less work.
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
August 30, 2013 at 9:24 am
You did not need to shrink, it would not have had any effect.
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
August 30, 2013 at 7:42 am
jeetsingh.cs (8/30/2013)
i have some questions that should i stick to this field or switch to BI as a SQL Developerlearning SSIS .
Which do you enjoy more?
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
August 30, 2013 at 6:55 am
kevaburg (8/30/2013)
There is no benefit.
Then I really must wonder why the ability to do it is there.
Many reasons. Performance is not one of them though
What happens when, on...
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
August 30, 2013 at 6:42 am
You're getting errors because GO is not a T-SQL command. It's a batch-breaker, designates where the client tool breaks commands apart to send the batches to SQL Server.
Take the GOs...
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
August 30, 2013 at 6:36 am
kevaburg (8/30/2013)
If log files don't get proportional fill then what would be the benefit of distributing them among multiple spindles?
There is no benefit.
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
August 30, 2013 at 6:33 am
kevaburg (8/30/2013)
The backup with truncate would reduce its size but the proprtional...
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
August 30, 2013 at 6:28 am
Viewing 15 posts - 11,866 through 11,880 (of 49,552 total)