Konu: sql enteresan makaleler
diye bir başlık açtım, bulduğumuz enteresan / önemli konuları tek başlıkta paylaşmak için...
Hidden Formatting Troubles with STR()
http://www.sqlservercentral.com/articles/T-SQL/71565/
Giriş yapmadınız. Lütfen giriş yapın yada kayıt olun.
diye bir başlık açtım, bulduğumuz enteresan / önemli konuları tek başlıkta paylaşmak için...
Hidden Formatting Troubles with STR()
http://www.sqlservercentral.com/articles/T-SQL/71565/
sql dosyalarının büyümesini monitor ve kayıt için:
http://www.sql-server-performance.com/a … th_p1.aspx
In this article I introduce a simple process that saves tables size information at points in time which latter allows for tracking down table growth over time.
The process is useful in monitoring data growth over time and lets you see what tables are growing rapidly in what databases and can also help in estimating future growth and disk space requirements. In addition it can help prevent unexpectedly running out of disk space, or if you are already in that situation then quickly find the table(s) that for some reason have grown more than excepted and are the source to the problem.
tablolardakı kayıt sayısının bulma
http://www.sqlservercentral.com/articles/T-SQL/67624/
At some point in time we've all had to find out how many rows are in a table. The first answer you'll usually get when you ask someone how to do it is select count(*) from [table], however there are two problems with this approach: First, a table scan is required to figure out the answer; do a count(*) against a million row table and you're looking at hundreds of thousands of reads (and likely several minutes waiting for the result). Second, the count(*) method doesn't work well if you want to know how many rows are in every table in your database.
Makaleye daha bakmadim ama yillardir benim kullandigim (reccount - rowcount diye snippet yaptim) - sysindexes'i sorguluyor sadece:
SELECT object_name(si.id),
si.rowcnt,
si.rows
FROM [sys].[sysindexes] si
INNER JOIN [sys].[TABLES] st
ON si.id = st.[object_id]
WHERE si.indid<2 AND st.is_ms_shipped = 0
ORDER BY rowcnt DESC
çeşitli JOIN leri anlamak isteyen arkadaşlar için
http://www.sqlservercentral.com/articles/T-SQL/67941/
Find which port SQL Server is using to establish connections
By default, SQL Server listens on port 1433 for TCP/IP connections and 1434 for UDP broadcasts. But what if this was changed and what about a named instance? You can find the listener port in a few ways: .......
http://www.sqlservercentral.com/article … ing/73238/
faydalanacak arladaşlara : Map IP Address to a Geographical Location
http://www.sqlservercentral.com/articles/SQL+Server/67215/
On the Internet there is the concept of web site analytics that helps track all the visitors' activities and usage patterns. One of the dimensions to track is the geographical information of the visitors, which can be obtained by using the IP address information that is collected when a user lands on a Website. In this article, I will describe a simple process that enables your reporting system to display the geographical information of the visitors. ...