SQL Server upto 2008 (supposedly fixed in 2012) has a known bug regarding the scope_identity() function. It may return incorrect values when running a parallel insert.
Source:
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=328811
SELECT name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%User_name()%’
Goal: look for “User_name()” in all the stored procedures
Result: the query will return the name of all the stored procedures containing this “User_name()” text.
Label control does not support multi line text wrap feature, however TextBlock control does. To use TextWrap feature in label, set the following:
To invoke button click event by:
pressing Enter key, set IsDefault=”True”
pressing Esc key, set IsCancel=”True”
Top-down (Design by Analysis) – Requirements analysis, Logical DB design, Physical DB design
Database design is the process of creating a business model that you use to convert business objects into database components (tables & views). Data modeling aims to produce a complete, accurate, and consistent representation of objects and the relationships between them in the real world.
DBCC FREEPROCCACHE [WITH NO_INFOMSGS]
DBCC FREESESSIONCACHE [WITH NO_INFOMSGS]
DBCC FREESYSTEMCACHE (‘ALL’) [ WITH [MARK_IN_USE_FOR_REMOVAL] , [NO_INFOMSGS] ]
Key:
————————————————————————————————————————————————————-
CHECKPOINT [duration]
This will write to disk all those data pages in the buffer cache of the current database which have been modified, but not yet written to disk.
————————————————————————————————————————————————————-
DBCC DROPCLEANBUFFERS [WITH NO_INFOMSGS]
This command is useful to test queries with a cold buffer cache without shutting down and restarting the server. To produce a ‘cold’ buffer cache with all dirty pages written to disk, first use CHECKPOINT.
————————————————————————————————————————————————————-
Refer to the links below for more information on DBCC commands:
http://ss64.com/sql/dbcc_free.html
http://ss64.com/sql/checkpoint.html
http://ss64.com/sql/dbcc_dropclean.html
Instead of checking for process name and process owner, try Mutex. Mutex, Mutual Exlusion, is synchronization primitive that can be used for inter-process synchronization (owned by a single thread at any given time). http://msdn.microsoft.com/en-us/library/system.threading.mutex.aspx
[DllImport("user32.dll")]
[return: MarshalAs(UnmanagedType.Bool)]
static extern bool SetForegroundWindow(IntPtr hWnd);
static void Main()
{
bool createdNew = true;
Mutex mutex = new Mutex(true, "ApplicationName", out createdNew)
if (createdNew)
{
//start the application
}
else
{
//put the focus on the application
Process current = Process.GetCurrentProcess();
foreach (Process process in
Process.GetProcessesByName(current.ProcessName))
{
if (process.Id != current.Id)
{
SetForegroundWindow(process.MainWindowHandle);
break;
}
}
}
}
more detail: http://iridescence.no/post/CreatingaSingleInstanceApplicationinC.aspx
When Intel releases its new architecture, Sandy Bridge, Intel also releases its new processors: i3, i5 and i7.
i3 has dual core base, hyper threading support, and virtualization. It’s known to perform closely to lower end Core 2 Quad processors.
Comparing to i3, i5 will give a noticeable difference in term of speed. There are 2 type of i5: dual core (32nm technology, hyper threading support, virtualization support, and Turbo Boost technology) and quad core (45nm technology, virtualization support and Turbo Boost technology, but do not have hyper threading support).
Comparing to i5, i7 promises to be faster. However, unless you’re running an application that uses 8 threads, you won’t notice much differences between the two. There are two different chip sets for i7, LGA1156 (800s) or LGA1366 (900s).
—————–
Hyper-Threading is Intel’s simultaneous multi-threading technology that presents each physical core as two logical cores to an operating system.
Click here to download the shortcuts file from Microsoft website
I’m trying to restore a database from .bak file and receive this error:
Cannot open backup device. Operating system error 5 (Access is denied). RESOTRE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
My attempts:
I did both of these and it works.
