Tag | MSSQL Posts

SQL Server together with other RDBMS, are the most memory consuming applications on our servers, and this is because, RDBMs usually cache objects into the memory to take advantage of the speed that physical memory offers. Sadly when windows feels that its physical memory is currently not enough for a driver and/or processes that is requesting some resources, it is forced to trim some of currently running application’s memory working set. Now that is bad news for SQL Server because windows will be ...
Here we are at the second week's task for the Manhattan Project: switching the user's database to MSSQL instead of SQLite. I'll be honest, there weren't any valuable resources I found for assistance in the creation of this tutorial. Mostly it was a combination of Try / Fail and guessing based on what I saw in the code for the MSSQL dll in the project. I might say that there weren't resources, but what I mostly mean is no tutorial. There are some .sql files to help get the database started, but that's ...
Most of you would rather the the first title before or. Can't Remember where I got most of this script(if you know please send me a hate email) however I did some enhancements and I am reposting it. DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf where -- ONLINE s_mf.state = 0 -- Only look at databases to which we have access and has_dbaccess(db_name(s_mf.d... = 1 -- ...
Download Video FeedSync (Project) Astoria Offline (Project) Take Data offline? Alter Remote Offline Data and use FeedSync to update when connected. Reasons: App availability Network Utilization Lower costs Leverage client UI Leverage Service Extend for collaboration Flexible: Write a provider for Service Desktop Devices Protocols extensions Metadata Handles arbitrary topology peer to peer mesh and point to point Layers: End to End Solutions Ado.NET Sync Astoria Offline Protocol and Store Providers ...
So I get this email. I forgot/lost the sa password. What to do? So I scrub the google database. Looking for an answer: Source Forgot or lost your sa password? Don't worry, there is a way out. Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password: sp_password @new = 'will_never_forget_again', @loginame = 'sa' Technorati Tags: SQL 2000, MSSQL, Microsoft, ...