Posted
by jinsungy
on Stack Overflow
See other posts from Stack Overflow
or by jinsungy
Published on 2010-03-18T14:07:44Z
Indexed on
2010/03/18
14:11 UTC
Read the original article
Hit count: 315
What is the "Attachment" data type's equivalent in SQL Server 2008?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and…
>>> More
as seen on Super User
- Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files.
In one case, the user has 2007 on his PC and opend the front end in 2007. No problems.
When the the user is done, he clicks a button that executes a macro full of update queries. The macro…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products.
>>> 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
