Viewing 15 posts - 2,851 through 2,865 (of 3,738 total)
I would start with Exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance.
There are a lot of simulation questions on this Exam. If you do not have the experience look...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 2:20 pm
You may want to try the last post on the following thread:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 1:46 pm
kickersdj (6/16/2011)
Table 1
ProjectMain_sales_Rep,Assoc1_SalesRep,Assoc2_SalesRep,Assoc3_SalesRep,Spend
Alpha_1,100001, ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 1:35 pm
To expand on Steve's comment:
If your instance name is contained in a string variable, make sure you do either:
string server = "myServer\\myInstance"; or
string server = @"myServer\myInstance";
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 1:25 pm
laddu4700 (6/17/2011)
So I want to know if there any other option for making the diagram more clear. (ex : JPEG image)
And also wondering can I take the hardcopy of diagram?
Exporting...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 1:02 pm
The following books by Itzik Ben-Gan are very good:
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Inside Microsoft® SQL Server® 2008: T-SQL Querying
Under the other issues category Microsoft® SQL Server®...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 12:24 pm
Personally I would find out of the Database is in use and by who and go from there?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 11:59 am
I usually check out Amazon.com first. Many books are not in Stock in the book stores.
You can read the reviews and if they have a Look inside you can look...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 11:38 am
mike 57299 (6/18/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 11:33 am
The following script can be used to detemine if a Database is currently in use.
USE Master
DECLARE @dbid INT
SELECT @dbid = dbid FROM sys.sysdatabases WHERE name = ”
IF EXISTS (SELECT spid...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 11:27 am
Robert Magrogan (6/19/2011)
Microsoft Access can be a marvelous Front End application to a SQL Server database, IF you plan well.
In my opinion even if you do plan well...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2011 at 11:20 am
raghudatta (6/17/2011)
Can you explain the details how install and connect to db2 through ssis it would be very helpful....
Have you client on the link provided to install the client?
After installing...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 17, 2011 at 12:49 pm
What is the exact requirement for your homework assignment?
I would take a close look at it and assign the appropriate permissions wheter it be at the database or server level.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 13, 2011 at 10:55 am
It is possible to have more than one person with the same name.
You can define UserName as a unique constraint but if more than one person has the same name...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 13, 2011 at 8:58 am
I have to admit that I do not like the design.
Where are you getting your data from?
In your code you always want to INSERT into the Payment Item Table.
Then you...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 13, 2011 at 8:40 am
Viewing 15 posts - 2,851 through 2,865 (of 3,738 total)