Viewing 15 posts - 5,581 through 5,595 (of 49,552 total)
It won't crash. If you exceed the limit, you'll get an error.
That said, you probably want to do that kind of crosstab in the application tier, the built in...
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 16, 2015 at 1:10 pm
Traceflag 1222 is to get the deadlock graph written to 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
June 16, 2015 at 1:08 pm
yb751 (6/16/2015)
If so than you could (ironically) make use of the LAG function. Otherwise Jeff's solution will work just fine.
Unless I'm missing something, LAG won't produce the results he...
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 16, 2015 at 1:07 pm
In that case, can you please post some sample data with the gaps that you expect and show what the results you want are?
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 16, 2015 at 1:05 pm
pederson1234 (6/16/2015)
great thanks...Also what is the maximum number of columns that can be used in a large data set? "Large" meaning 5 columns by 20 million rows?
Errr????
The limit 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
June 16, 2015 at 1:03 pm
karend211 34657 (6/16/2015)
I have one other question... Is mirroring an effective solution to implement a standby database in case of corruption?
It's part of a solution.
No, if you get corruption...
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 16, 2015 at 12:59 pm
DeWayne_McCallie (6/16/2015)
Wow I'm on the MSDN download site and there is a download with that name (I have already downloaded it). I must be tripping!
You're right, there is.
It's Core-licensing...
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 16, 2015 at 12:57 pm
karend211 34657 (6/15/2015)
We do sql database snapshot backups through a third party software on hourly intervals.
Check your SQL error log. Unless you see messages in the log corresponding to those...
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 15, 2015 at 8:30 am
Copying files is not a backup strategy because, unless the tool copying the files syncs with SQL Server, the 'backed up' files may very well be useless.
You need to put...
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 15, 2015 at 5:13 am
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
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 15, 2015 at 5:09 am
If you don't care about the database, drop it.
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 14, 2015 at 8:47 am
keshab.basnet (6/13/2015)
DB crashed means user production user data file is not working.
Which means what exactly?
And it's kinda important because depending on exactly what you mean by 'not working', we...
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 14, 2015 at 8:44 am
DO NOT take the database offline!
Please post the full and complete, unedited output of
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
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 13, 2015 at 5:45 am
Not sure, but I suspect it'd be data file usage.
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 12, 2015 at 1:54 pm
Welsh Corgi (6/12/2015)
So use the command line for everything?
Hell no. Use SSMS from a client machine. There's pretty much no case I can think of where you'd need to use...
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 12, 2015 at 10:38 am
Viewing 15 posts - 5,581 through 5,595 (of 49,552 total)