I have an application that has a specified database connection that I either can't or don't want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?
2008-11-18
4,765 reads
Having your users walk into a cold cache on a morning is something that will cause them to have slower running queries initially. Cache warming takes care of a lot of that by executing typical queries against the newly processed cube and thereby building the cache ready for your users
2008-11-18
2,086 reads
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
2008-11-18
678 reads
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
2008-11-18
89 reads
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
2008-11-18
673 reads
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
2008-11-17
876 reads
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
2008-11-17
569 reads
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
2008-11-17
547 reads
This article examines the Recovery Model options used by SQL Server 2008 and the various methods that can be used to backup a database such as Differential and Transaction Logging. In addition, Transaction Logs, the mechanism that makes Recovery Models possible will be introduced.
2008-11-17
3,317 reads
Previous versions of SQL Server were not that great at keeping track of object dependencies. The reason for this was due to the fact that all object dependencies were tracked by the ID of the object, which meant that the object had to exist first.
2008-11-17
2,093 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers