-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I have a table in which there are two columns : 1. import type, 2. Excel import template.
The second column - "Excel import template" should store the whole excel file.
How would I save excel file in databse...can I use binary datatype column, convert excel file to bytes and save the same …
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but somethings, and lately more often, we have started receiving this error from the db when openning the connection:
A connection was successfully established with the server, but then…
>>> More
-
as seen on Code Project
- Search for 'Code Project'
Demonstrates how to Adjust the SQL2005 MRU using Reflection and the SQL Assemblies
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
How can I increase the limit of worker threads from the default 10 for SQL Server 2005 SqlAgent? I have 9 jobs that run almost continuously and that leaves only one available thread for the rest of the scheduled jobs. Oftentimes, when no thread is available, I will see the jobs in "Waiting for worker…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a Winforms application and I use EntLib to connect to a SQL Server 2005 DB. The application is working ok, but sometimes, and lately more often, we have started receiving this error from the db when opening the connection:
A connection was successfully established with the server, but then…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Hello,
I am trying to install Sql Server 2008 Business Intelligence Development Suite on VS2008 in a Windows 7 (64bit) machine.
The installer is aborting with an unspecified error for which I have not been able to find any error anywhere.
Has anyone had the same problem with BIDS?
Thanks,
Eduardo…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I want to setup a sqlserver 2008 developeredition on my windows-vista notebook but the setup-check want me to reboot first. But this doesn't help after reboot the setup want a reboot again.
I got the tip: You can open Regedit, and modify this key"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet?\Control\Session…
>>> More
-
as seen on Super User
- Search for 'Super User'
Not sure what changed but looks like my security credentials have been monkeyed with. Since yesterday evening after I disconnected from our corporate network and rebooted my laptop at home, I am unable to start the instance of SQL2K8. The service is set to run under NT AUTHORITY\NETWORK SERVICE account…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the proyect a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer for the Data Files and for the File System of the Proyect.
I read that SQl Clustering does not provide…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am testing the speed of inserting multiple rows with a single INSERT statement.
For example:
INSERT INTO [MyTable] VALUES (5, 'dog'), (6, 'cat'), (3, 'fish)
This is very fast until I pass 50 rows on a single statement, then the speed drops significantly.
Inserting 10000 rows with batches of 50…
>>> More
