Day 30: More Fatal Errors and BUGs
Day 30 More Fatal Errors and BUGs
For sql server 2000 and earlier you may get 5242 and 5243 corruption in...
2011-11-30
2,128 reads
Vinay Thakur
Day 2: Log file grown high cannot shrink log file.(available size in – negative)
Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...
2011-11-29
523 reads
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Error 823: IO error OS cannot read the data
Error: 823,...
2011-11-29
14,050 reads
Day 28: Linked server errors
This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011 Day 28: Linked server errors Linked...
2011-11-28
623 reads
TransactionLog Internals
Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one transaction log (ldf) file...
2011-06-22
641 reads
Difference between Checkpoint and LazyWritter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
546 reads
Difference between Checkpoint and LazyWriter
Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...
2011-06-20
1,035 reads
How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
477 reads
Isolation level and Locks
Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends...
2011-06-08
846 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
579 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Semanggi Telpon/wa:0813.7887.595
BCA KCP Semanggi Telpon/wa:0813.7887.595.Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan...
BCA KCU PURWAKARTA TLP/WhatsApp 08216977701
Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta, Kabupaten Purwakarta,...
Kantor BCA KCP Buah Batu Telp/wa 085169998803
Telp/wa 085169998803 Jl. Buah Batu No.192, Cijagra, Kec. Lengkong, Kota Bandung, Jawa Barat 40226
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers