Viewing 15 posts - 5,581 through 5,595 (of 49,571 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...
June 16, 2015 at 1:10 pm
Traceflag 1222 is to get the deadlock graph written to the error log.
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...
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?
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...
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...
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...
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...
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...
June 15, 2015 at 5:13 am
June 15, 2015 at 5:09 am
If you don't care about the database, drop it.
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...
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?
June 13, 2015 at 5:45 am
Not sure, but I suspect it'd be data file usage.
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...
June 12, 2015 at 10:38 am
Viewing 15 posts - 5,581 through 5,595 (of 49,571 total)