Topics
Started by
Posts
Last post
Hi all, I am trying to execute the following query SELECT TOP 100 ADDRESSLINE1 FROM MST_ADDRESS WHE…
3 replies
Hello, Is there any commands or datediff functions that will always return the results for a prior …
7 replies
When declaring a primary key on a create table statement... PRIMARY KEY CLUSTERED ( [ID] ASC )WITH…
4 replies
I am a little confused on just how much an index can help here. I regularly need to run searches th…
11 replies
I have 400 usersnames that I need to import from a spreadsheet. I need to create sql logins for eac…
8 replies
I need to identify the situations when such tables are used? please let me know thanks.
2 replies
I had incorrectly posted this to the SQL server 2000 forum, but I am currently working with 2008: S…
1 replies
Hi folks, I am trying to use the “SERVERPROPERTY” function in a stored procedure to get data from …
5 replies
Can somebody please advise me on the best Data Types to use for various Coloums. Im adding the oll…
8 replies
Hello All, Here is my problem: create table #temp ( id int, hoursFrom int, minsFrom int, hoursTo in…
1 replies
Usually, when you want to avoid compilation of a command or 1-2 lines, you add the double line '--'…
2 replies
Is it possible to capture execution plan for only a queries which take more 5 minutes using server …
1 replies
Hi, I have attached a sample of user interface that I found interesting, and I am trying to figure…
7 replies
Hi guys I running a query that seems to be heavy. So I m checking the time used to complete, the ex…
3 replies
I recently installed SQL Server on my computer for the first time. Now I notice that my hard disk(s…
14 replies
Viewing 15 topics - 4,081 through 4,095 (of 5,050 total)
You must be logged in to create new topics.